| CTRL+SHIFT+
"$" |
Apply
the Currency format with two decimal places |
| CTRL+SHIFT+
"#" |
Apply
the Date format with the day, month, and year |
| CTRL+SHIFT+
"~" |
Apply
the General number format |
| CTRL+SHIFT+
"!" |
Apply
the Number format <,000.00> |
| CTRL+SHIFT+
"&" |
Apply
the outline border |
| CTRL+SHIFT+
"%" |
Apply
the Percentage format with no decimal places |
| ESC |
Cancel
an entry in the cell or formula bar |
| DELETE |
Clear
the contents of the selection |
| CTRL+C |
Copy
the selection |
| CTRL+X |
Cut
the selection |
| CTRL+
"-" |
Delete
the selection |
| CTRL+1 |
Display
the Format Cells dialog box |
| CTRL+O |
Display
the Open dialog box |
| SHIFT+F12 |
Display
the Save as dialog box |
| F2 |
Edit
the active cell |
| BACKSPACE |
Edit
the active cell and then clear it |
| CTRL+0 (zero) |
Hide
columns |
| CTRL+9 |
Hide
rows |
| CTRL+SHIFT+
"+" |
Insert
blank cells (Rows, Columns, or Cells) |
| CTRL+V |
Paste
the selection |
| CTRL+SHIFT+
"_" |
Remove
outline borders |
| CTRL+S |
Save
the active workbook |
| CTRL+SPACEBAR |
Select
the entire column |
| SHIFT+SPACEBAR |
Select
the entire row |
| CTRL+A |
Select
the entire worksheet |
| CTRL+7 |
Show
or hide the Standard toolbar |
| ALT+7 |
Show
the Tools menu (Tools button) |
| CTRL+Z |
Undo
the last action |
| CTRL+SHIFT+
")" |
Unhide
columns |
| CTRL+SHIFT+
"(" |
|
Software Guide 2003