Go to content Go to navigation Go to search

What are worksheets

Microsoft Excel consists of worksheets.

There are 3 worksheet by default.

Each worksheet contains columns and rows.

The columns are lettered A to Z and then continuing with AA, AB, AC and so on.

The rows are numbered 1 to 1,048,576

worksheet

Cells

You enter your data into the cells on the worksheet.

The combination of a column coordinate and a row coordinate make up a cell address.

For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1.

Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet

Move around a Worksheet

Move UP and DOWN, LEFT and RIGHT on the Worksheet with arrow key on your keyboard.

arrow-keys

Select Cells

Selecting one cell

Click on the cell you want to select

Select B10

Selecting multiple cells

Hold down the left mouse button and dragging the mouse over the area.

Exercise

Select cells from A1 to F10

Selecting multiple cells at different locations

Press and Hold [ Ctrl] key and Click on the cells you want to select.

Exercise

Select A1, B10, C12, F3 together.

  • Share/Bookmark