Excel 2013 Keyboard Shortcuts Flashcards
Learn commonly used Excel 2013 keyboard shortcuts
Create new workbook
Ctrl + N
Open workbook
Ctrl + O
Save workbook
Ctrl + S
Save as
F12
Print file
Ctrl + P
Open print preview
Ctrl + F2
Close current workbook
Ctrl + F4
Close Excel
Alt + F4
Copy a formula exactly …
First, double click on cell to open Edit Mode. Ctrl + C to copy formula. Click Esc. Ctrl + V to paste contents in new cell.
Open the Format Cells window…
Ctrl + 1
Highlight an entire data set …
Ctrl + * (asterisk)
Jump
Ctrl + Arrow
Go to the top of a column in a data set…
Ctrl + Up Arrow
Go to cell A1
Ctrl + Home
Go to last row and column in data set.
Ctrl + End
Highlight a portion of a column
Click, Shift, Click
Currency Number Format
Ctrl + Shift + 4
Sum
Alt + = (equal)
Alt keys
Alt
Pivot Table
Alt, N, V, T
Page Setup
Alt, P, S, P
Starting at the top highlight an entire column with data
Ctrl + Shift + Down Arrow
Undo
Ctrl + Z
Puts thing in a cell and moves selected cell down
Enter
Puts thing in a cell and stays in selected cell
Ctrl + Enter
Puts thing in a cell and moves selected cell to the right
Tab
Put thing in a cell and moves selected cell up
Shift + Enter
Put thing in a cell and moves selected cell to the left
Shift + Tab
Toggle absolute cell reference
F4
Move from corner to corner of data set
Ctrl + . (period)
Cut cell range
Ctrl + X
Paste everything copied including source column width…
Press Ctrl + V, Tap Ctrl, Tap W
Turn on / turn off filters
Ctrl + Shift + 1
Edit a cell
F2
Toggle show formula
Ctrl + ~
Insert table
Ctrl + T
Add hyperlink
Ctrl + K
Undo the undo
Ctrl + Y
Hard coding today’s date
Ctrl + ;
Current time:
Ctrl + Shift + ;
General number formatting
Ctrl + Shift + ~
Shift & Outline border to the selected cells.
CTRL
Change Date format with day, month and year.
CTRL Shift #
Change Time format with hour and minute, AM or PM.
CTRL Shift @
For the current time.
CTRL Shift :
For current date.
CTRL ;
Hide selected rows.
CTRL 9
Hide selected columns.
CTRL 0
Display Formulas/Alternate in the worksheet.
CTRL `
To insert Hyperlink.
CTRL+K
Opens up the Find and Replace dialog box.
CTRL+H
Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.
CTRL+R
Hides or displays the standard toolbar.
CTRL+7
This creates a chart out of the data in the current range (selected cells).
ALT+F1
Inserts a new worksheet into a workbook.
ALT+SHIFT+F1
Switches between the worksheet, Ribbon, task pane, and Zoom controls.
F6
The reverse of the F6 shortcut.
SHIFT+F6
Switches to the next workbook window when multiple workbook windows are open.
CTRL+F6
Applies the currency format to the selected cells.
CTRL+SHIFT+$
Alternates between showing the value of a cell and the formula in the worksheet. Great for complex worksheets.
CTRL+`
Fill down command on the selected cells. Fill down copies the content and format of the topmost cell into the cells below.
CTRL+D
Fill right command on the selected cells. Fill right copies the content and format of the leftmost cell to the cells to the right.
CTRL+R