85+ Keyboard Shortcuts For Microsoft Excel
Formatting |
|
|
|
Keystroke |
Function |
[Ctrl]B |
Bold the selection |
[Ctrl]I |
Italicize the selection |
[Ctrl]U |
Underline the selection |
[Ctrl]5 |
Strike through the selection |
[Alt] and ' |
Open the Style dialog box |
[Ctrl]1 |
Open the Format Cells dialog box |
[Ctrl][Shift]~ |
Apply General format |
[Ctrl][Shift]$ |
Apply Currency format |
[Ctrl][Shift]% |
Apply percentage format |
[Ctrl][Shift]# |
Apply Date format |
[Ctrl][Shift] @ |
Apply Time format |
[Ctrl][Shift]! |
Apply Number format |
[Ctrl][Shift]^ |
Apply Exponential number format |
[Ctrl][Shift]& |
Apply an outline border to selection |
[Ctrl][Shift] and _ |
Remove outline border from selection |
|
|
Navigation |
|
|
|
Keystroke |
Function |
[Ctrl][Page Down] |
Move to the next worksheet in a workbook |
[Ctrl][Page Up] |
Move to the previous worksheet in a workbook |
[Ctrl][F6] |
Cycle between open workbooks |
Arrow keys |
Move one cell up, down, left, or right |
[Ctrl] and an arrow key |
Move to the edge of the data region |
[Home] |
Move to the beginning of a row |
[Ctrl][Home] |
Move to the beginning of a worksheet |
[Ctrl][End] |
Move to the end of the used portion of a worksheet |
[F6] |
Move between panes in a split worksheet |
[Ctrl][Backspace] |
Display the active cell |
[Enter] |
Move down a cell in a selected range |
[Shift][Enter] |
Move up a cell in a selected range |
[Shift][Tab] |
Move one cell to the left in a selected range |
[Ctrl] and . (period) |
Move from corner cell to corner cell in a selected range |
|
|
Selection techniques |
|
|
|
Keystroke |
Function |
[Shift][Spacebar] |
Select a row |
[Ctrl][Spacebar] |
Select a column |
[Ctrl]A |
Select an entire worksheet |
[Shift][Home] |
Select from current cell(s) to the beginning of the row |
[Shift][End][Enter] |
Select from current cell(s) to last used cell in row |
[Ctrl][Shift][Home] |
Select from current cell(s) to the beginning of the worksheet |
[Ctrl][Shift][End] |
Select from current cell(s) to the end of the used portion of a worksheet |
[Ctrl] and * |
Select the data region surrounding the active cell |
[Ctrl][Shift]O |
Select all cells that contain a comment |
[Ctrl] and [ |
Select cells that a selected formula directly references |
[Ctrl] and ] |
Select formulas that directly reference the active cell |
|
|
Workbook basics |
|
|
|
Keystroke |
Function |
[Ctrl]O |
Open a workbook |
[Ctrl]N |
Create a new workbook |
[Ctrl]S |
Save a workbook |
[F12] |
Open the Save As dialog box |
[Ctrl]P |
Print a workbook |
[Ctrl]W |
Close a workbook |
[Shift][F11] |
Insert a new worksheet |
[Ctrl]9 |
Hide selected rows |
[Ctrl][Shift]9 |
Display hidden rows in selection |
[Ctrl]0 |
Hide selected columns |
[Ctrl][Shift]0 |
Display hidden columns in selection |
[Ctrl]F |
Open the Find tab of the Find And Replace dialog box |
[Ctrl]H |
Open the Replace tab of the Find And Replace dialog box |
[F7] |
Run a spelling check on a worksheet or selected text |
|
|
Working with data |
|
|
|
Keystroke |
Function |
[Enter] |
Complete an entry and move to the next cell |
[Alt][Enter] |
Insert a new line within a cell |
[F2] |
Enable editing within a cell |
[Ctrl][Enter] |
Fill selected cells with an entry you type |
[Ctrl]D |
Fill data down through selected cells |
[Ctrl]R |
Fill data through selected cells to the right |
[Ctrl][F3] |
Create a name |
[Ctrl]K |
Insert a hyperlink |
[Ctrl] and ; (semicolon) |
Insert the current date |
[Ctrl] and : (colon) |
Insert the current time |
[Ctrl]X |
Cut the selected text or objects to the Clipboard |
[Ctrl]C |
Copy the selected text or objects to the Clipboard |
[Ctrl]V |
Paste the contents of the Clipboard |
[Ctrl]Y |
Repeat last action |
[Ctrl]Z |
Undo last edit |
[Ctrl][Delete] |
Delete from the insertion point to the end of the line |
[Ctrl][Shift]+ |
Add blank cells |
[Ctrl]- (hyphen) |
Delete selected cells |
[F11] |
Create a chart from a range of data |
|
|
Formula shortcuts |
|
|
|
Keystroke |
Function |
= |
Begin a formula |
[Ctrl][Shift][Enter] |
Enter a formula as an array |
[Shift][F3] |
Display the Insert Function dialog box (Paste Function in Excel 97) |
[F3] |
Paste a defined name into a formula |
[Alt]= |
Insert a SUM AutoSum formula |
Type a function in the Formula |
Display the Function Arguments dialog box |
bar and press [Ctrl]A |
|
[Ctrl][Shift] and " |
Copy the value from the cell above the current cell into the current cell |
[Ctrl] and ' |
Copy a formula from the cell above the current cell into the current cell |
[Ctrl] and ` |
Toggle between display of formulas and cell values |
[F9] |
Calculate values for sheets in all open workbooks |
[Shift][F9] |
Calculate values for the current worksheet |
[Esc] |
Cancel an entry you're making in a cell or in the formula bar |