Contents
An Introduction to Keyboard Shortcuts and KeyTips
Shortcuts for Basic Excel Actions
Shortcuts for Navigating Excel Documents
Shortcuts for Selecting, Finding, and Replacing Cells, Text, and Data
Shortcuts for Copying and Moving Text and Data
Shortcuts for Inserting and Deleting Cells, Text, Data, and Graphics
Shortcuts for Formatting Cells and Text
Shortcuts for Working with Numbers and Data
Shortcuts for Printing Spreadsheets
Shortcuts for Reviewing, Protecting, and Sharing
Function Key Quick Reference
Learn more with these titles from Barnes & Noble
 |
Previous: Shortcuts for Navigating Excel Documents |
Next: Shortcuts for Copying and Moving Text and Data |
 |
|
 |
 |
 |
|
Shortcuts for Selecting, Finding, and Replacing Cells, Text, and Data
Selecting Cells, Text, and Data
Action |
Keyboard Shortcut |
|
Select the cells adjacent to the active cell |
Ctrl+Shift+8 |
|
Select the entire worksheet |
Ctrl+A; press once to select all cells with data; press again to select every cell |
|
Select the entire current column |
Ctrl+Space Bar |
|
Select the entire current row |
Shift+Space Bar |
|
Select all cells that contain comments |
Ctrl+Shift+O |
|
Select the entire current region |
Ctrl+Shift+* |
|
Select the first cell in a row |
Home |
|
Select the first cell (A1) |
Ctrl+Home |
|
Switch the active cell among the four corner cells of a selection (press repeatedly to cycle through the four corners) |
Ctrl+. (period) |
|
Select cells that are direct precedents (through a formula or function) of the active cell |
Ctrl+[ |
|
Select cells that are direct dependents (through a formula or function) of the active cell |
Ctrl+] |
|
Select all cells that are precedents (through a formula or function) of the active cell |
Ctrl+Shift+[ |
|
Select all cells that are dependents (through a formula or function) of the active cell |
Ctrl+Shift+] |
|
Select cells in the selection that are not equal to the
active cell |
Shift+Ctrl+\ |
|
Extend a selection down one row |
Shift+Down Arrow |
|
Extend a selection up one row |
Shift+Up Arrow |
|
Extend a selection left one column |
Shift+Left Arrow |
|
Extend a selection right one column |
Shift+Right Arrow |
|
Extend a selection to a region’s first occupied cell |
Shift+Ctrl+Up Arrow |
|
Extend a selection to a region’s last occupied cell |
Shift+Ctrl+Down Arrow |
|
Extend a selection to a region’s leftmost occupied cell |
Shift+Ctrl+Left Arrow |
|
Extend a selection to a region’s rightmost occupied cell |
Shift+Ctrl+Right Arrow |
|
Extend a selection to the first cell in a worksheet |
Shift+Ctrl+Home |
|
Extend a selection to the last cell in a worksheet |
Shift+Ctrl+End |
|
Extend a selection to the first cell in a row |
Shift+Home |
|
Extend the selection to the last cell in a row |
Shift+End |
|
Extend a selection by one Page Up command |
Shift+Page Up |
|
Extend a selection by one Page Down command |
Shift+Page Down |
|
Extend a selection by one Page Left command |
Shift+Alt+Page Down |
|
Extend a selection by one Page Right command |
Shift+Alt+Page Up |
|
Apply the current selection to the preceding worksheet (the worksheet to the left of the current worksheet on the worksheet tabs) |
Shift+Ctrl+Page Up |
|
Extend a selection to the following worksheet (the worksheet to the right of the current worksheet on the worksheet tabs) |
Shift+Ctrl+Page Down |
|
Collapse a selection to select the active cell only |
Shift+Backspace |
Finding and Replacing
Action |
Keyboard Shortcut |
|
Find specific text, data, or cell formatting or color |
Ctrl+F |
|
Repeat your previous find |
Shift+F4 |
|
Replace text, data, or cell formatting or color |
Ctrl+H |
| Acknowledgments & Disclaimer |
for just $2.95
► Handy, portable format
