Topic 7 – Notes



After completing this lesson, you should know:

  • Different methods to move around in a worksheet
  • Different methods to select portions of the sheet



There are several ways you can move around in a worksheet:

Click a cell

Go to that specific cell

Click the scroll arrow

Moves the view of the worksheet one row or column

Drag the scrollbar

Moves the view of the worksheet quickly

Click the sheet tab

Go to another sheet in the workbook

Scroll the mouse wheel

Move up or down in the worksheet

Press an arrow key

Selects an adjacent cell

Press Tab / Shift + Tab

Selects the cell one column to the right / left

Press Control + Home

Selects cell A1

Press Control + End

Selects the cell of the last row and last column of data

Press Home

Move to the first column in a row

Page Up / Page Down

Move a screen size up or down in the worksheet


Go to a specific cell



There are different methods to select portions of the sheet:

Click a cell

Select that one cell

Shift → or  ← or  ↑ or  ↓

Select or deselect cells

Click on the first cell and drag the mouse to select the range

Select a range of cells

Click on column name e.g. D

Select entire column

Click on row name e.g. 3

Select entire row

Click on blank cell in top left corner of worksheet

Select entire worksheet

Click on first cell, press and hold shift, click on last cell

Select adjacent cells

Click, press and hold control, click all the other cells, rows or columns you want to include in the selection

Select non-adjacent cells

Click anywhere in data → Ctrl A

Select database


Last modified: Wednesday, 28 April 2021, 3:00 PM