Topic 7 – Notes

NAVIGATION AND SELECTION IN EXCEL

 

After completing this lesson, you should know:

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

 

NAVIGATION

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

F5

Go to a specific cell

 

SELECTION

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