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 Inserting and Deleting Cells, Text, Data, and Graphics |
Next: Shortcuts for Working with Numbers and Data |
 |
|
 |
 |
 |
|
Shortcuts for Formatting Cells and Text
Formatting Text Within Cells
Action |
Keyboard Shortcut |
|
Open the Format Cells dialog box (to change font type, style, size, and so on) |
Ctrl+Shift+F |
|
Add or remove bold |
Ctrl+B or Ctrl+2 |
|
Add or remove underline |
Ctrl+U or Ctrl+4 |
|
Add or remove double-underline |
Alt+H, 3, D |
|
Add or remove italics |
Ctrl+I or Ctrl+3 |
|
Add or remove strikethrough |
Ctrl+5 |
|
Add a hyperlink (or edit an existing one) |
Ctrl+K |
Changing the Appearance of Cells
Action |
Keyboard Shortcut |
|
Open the Format Cells dialog box (to change various formatting options, such as cell color and cell borders) |
Ctrl+Shift+F, then press N, A, B or F to switch tabs |
|
Apply the border you’ve chosen to selected cells |
Ctrl+Shift+& |
|
Remove the border from selected cells |
Ctrl+Shift+_ |
|
AutoFit column width to cell contents |
Alt+H, O, I |
|
AutoFit row height to cell contents |
Alt+H, O, A |
Hiding and Unhiding Rows and Columns
Action |
Keyboard Shortcut |
|
Hide selected rows |
Ctrl+9 |
|
Hide selected columns |
Ctrl+0 |
|
Unhide hidden rows within a selection |
Ctrl+Shift+( |
|
Unhide hidden columns within a selection |
Ctrl+Shift+) |
| Acknowledgments & Disclaimer |
for just $2.95
► Handy, portable format
