• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Spreadsheet Basics > Selecting Cells

Selecting Cells

After data entry, selecting worksheet content is probably the task most frequently performed in Excel. Selecting cells and ranges tells Excel where you are and what parts of a sheet you intend to change, and is an integral step in most formatting, calculation, and editing procedures. To select an individual cell, click it or use any of the keyboard shortcuts shown in Table 2.1 for worksheet navigation to move to the desired cell.

Table 2.1. Keyboard Shortcuts for Selecting Individual Cells
Keyboard ShortcutSelects
EnterThe cell below the current cell.
TabThe cell to the right of the current cell.
Shift+TabThe cell to the left of the current cell.
Ctrl+HomeCell A1.
HomeThe first cell in the current row.
Ctrl+ArrowGoes to the last formatted cell in a row or column. If no formatting, goes to the last row or column of the spreadsheet.
Shift+ArrowSelects the entire range between the starting cell and the new destination cell.
Ctrl+Shift+ArrowSelects the entire range between the starting cell and the last formatted cell. If no additional cell formatting or content is entered, it selects the end of the spreadsheet row or column.
Ctrl+*Collapses the column of the current selection.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint