FINAN 4020 - Excel Hotkeys/Shortcut Keys
Save As
F12
Edit the selected cell
F2
Show names
F3
Display the go to dialog box
F5
Switch between the ribbon and task pane
F6
Spell check selected text and/or document
F7
Toggle extend selection
F8
Calculate the workbook
F9
Show hotkeys
[Alt]
Select visible cells
[Alt] [;}
Auto sum - sum all the cells above
[Alt] [=]
Open a combo box or filter list
[Alt] [Down]
Wrap text - when inside a cell this will start a new line in that cell
[Alt] [Enter]
Group using hot keys
[Alt],[A],[G],[G]
Sort in ascending order using hot keys
[Alt],[A],[S],[A]
Sort in descending order using hot keys
[Alt],[A],[S],[D]
Open sort dialog box using hot keys
[Alt],[A],[S],[S]
Filter a table or range using hot keys
[Alt],[A],[T]
Ungroup using hot keys
[Alt],[A],[U],[U]
Format using hot keys
[Alt],[H],[0]
Increase decimal using hot keys
[Alt],[H],[0]
Decrease indent using hot keys
[Alt],[H],[5]
Indent using hot keys
[Alt],[H],[6]
Decrease decimal using hot keys
[Alt],[H],[9]
Apply all borders using hot keys
[Alt],[H],[B],[A]
Remove the outline border from the selected cells using hot keys
[Alt],[H],[B],[N]
Apply a bottom border using hot keys
[Alt],[H],[B],[O]
Apply a top border using hot keys
[Alt],[H],[B],[P]
Apply outline border to the selected cells using hot keys
[Alt],[H],[B],[S]
Top and double bottom border using hot keys
[Alt],[H],[B],[U]
Delete cells using hot keys
[Alt],[H],[D]
Clear all using hot keys
[Alt],[H],[E],[A]
Insert cells using hot keys
[Alt],[H],[I]
Format accounting using hot keys
[Alt],[H],[K]
Conditional formatting using hot keys
[Alt],[H],[L]
Format percentage using hot keys
[Alt],[H],[P]
Paste values using hot keys
[Alt],[H],[V],[V]
Name a cell using hot keys
[Alt],[M],[M],[D]
Open name dialog box using hot keys
[Alt],[M],[N]
Insert pivot table using hot keys
[Alt],[N],[V]
Freeze and unfreeze panes using hot keys
[Alt],[W],[F],[F]
Insert new worksheet
[Alt][Shift][F1]
Cycle backward through open applications
[Alt][Shift][Tab]
Cycle forward through open applications
[Alt][Tab]
Move to next cell
[Arrow Key]
Copy the value from the cell above the active cell into the cell or the formula bar
[Ctrl] [']
Enter the current date
[Ctrl] [;]
Select all
[Ctrl] [A]
Copy
[Ctrl] [C]
Enter the same data or formula into all cells selected
[Ctrl] [Enter]
Move to beginning of line of text (or last nonblank row/column)
[Ctrl] [Home]
Alternate between displaying cell values and displaying formulas in the worksheet
[Ctrl] [~]
Hide columns
[Ctrl][0]
Open format dialog
[Ctrl][1]
Hide rows
[Ctrl][9]
Move to next section of text
[Ctrl][Arrow key]
Bold highlighted selection
[Ctrl][B]
Fill down command to copy the contents and format of the topmost cell of a selected range into the cells below.
[Ctrl][D]
Move to the end of line of text (or region)
[Ctrl][End]
Minimize / maximize currently selected window
[Ctrl][F10]
Print Preview
[Ctrl][F2]
Minimize current window
[Ctrl][F9]
Find
[Ctrl][F]
Find and Replace
[Ctrl][H]
Italic highlighted selection
[Ctrl][I]
New workbook
[Ctrl][N]
Bring up the print dialog box to begin printing
[Ctrl][P]
Switches between worksheet tabs, from left-to-right
[Ctrl][Page Down]
Switches between worksheet tabs, from right-to-left
[Ctrl][Page Up]
Displays the quick analysis options for your data when you have cells that contain that data selected
[Ctrl][Q]
Save
[Ctrl][S]
Selecting a range
[Ctrl][Shift][ Arrows]
Apply comma format
[Ctrl][Shift][!]
Applies the currency format with two decimal places (negative numbers in parentheses).
[Ctrl][Shift][$]
Applies the percentage format with no decimal places
[Ctrl][Shift][%]
Unhide rows
[Ctrl][Shift][(]
Unhide columns
[Ctrl][Shift][)]
Enter the current time
[Ctrl][Shift][;]
Select to end of line of text (or region)
[Ctrl][Shift][End]
Select to beginning of line of text (or cell a1)
[Ctrl][Shift][Home]
Applies the general number format
[Ctrl][Shift][~]
Select entire column
[Ctrl][Space]
Create a table
[Ctrl][T]
Move between open excel files
[Ctrl][Tab]
Underline highlighted selection
[Ctrl][U]
Paste
[Ctrl][V]
Cut
[Ctrl][X]
Redo last action (can be used multiple times)
[Ctrl][Y]
Undo last action (can be used multiple times)
[Ctrl][Z]
Delete cell content
[Del]
Create chart
[F11]
Help
[F1]
Cycle through absolute and relative (in formula)
[F4]
Selecting cells
[Shift][ Arrows]
Open context menu
[Shift][F10]
Insert new worksheet
[Shift][F11]
Adds or edits a cell comment
[Shift][F2]
Open the excel formula window
[Shift][F3]
Calculate the worksheet
[Shift][F9]
Select entire row
[Shift][Space]