An Excel worksheet can span 16,384 columns and 1,048,576 rows; fortunately, very few worksheets get this big, but knowing how to navigate through a worksheet is another critical Excel topic you’ll need to know before you can master Excel. This lesson explains the most common ways to navigate an Excel worksheet.
- Select a single cell by using:
- The Mouse: Click any cell with the cross pointer.
- The Keyboard: Move the cell pointer using your keyboard’s arrow keys.
To help you know where you are in a worksheet, Excel displays row headings, identified by numbers, on the left side of the worksheet, and column headings, identified by letters, at the top of the worksheet. Each cell in a worksheet has its own cell address made from its column letter and row number—such as cell A1, A2, B1, B2, etc. You can immediately find the address of a cell by looking at the Name Box, which shows the current cell address.
The Name Box is an easy way to get to the cell you want.
The Go To dialog box can be helpful when worksheets start getting very large. Here’s how to use it:
- Click the Find & Select button on the Home tab.
- Select Go To.
Press Ctrl + G to open the Go To dialog box.
- Enter or select the cell reference you want to go to.
- Click OK.
Excel jumps to the specified cell.
Excel has several shortcuts that make it fast to get around your worksheets; they’re included in this table:
|? or Enter||Down one row|
|? or Shift + Enter||Up one row|
|? or Tab||Right one column|
|? or Shift + Tab||Left one column|
|Home||To column A in the current row|
|Ctrl + Home||To the first cell (A1) in the worksheet|
|Ctrl + End||To the last cell with data in the worksheet|
|Page Up||Up one screen|
|Page Down||Down one screen|
|Ctrl + G||Opens the Go To dialog box where you can go to a specific cell address|