As a follow-up to last week’s Word version, here is a Cliffs Notes version for Excel. I’ll bet you’ll never guess what’s coming next week! 😎
The Basics:
CTRL + N ↔ Create a New workbook
CTRL + O ↔ Open an existing workbook
CTRL + S ↔ Save current workbook
CTRL + P ↔ Print
Selecting:
CTRL + SPACE ↔ Select entire column
SHIFT+ SPACE ↔ Select entire row
CTRL + A ↔ Select entire worksheet
SHIFT + HOME ↔ Select range from current cell to far left
SHIFT + END + arrow ↔ Select range from start cell to end in direction of arrow
CTRL + SHIFT + HOME ↔ Select all from current cell to A1
Navigating:
CTRL + PageUp ↔ Jump to previous sheet/tab
CTRL + PageDown ↔ Jump to next sheet/tab
F5 ↔ Open the Go to… dialog
CTRL + HOME ↔ Jump to top left (A1 or 1st cell of frozen sheet)
CTRL + END ↔ Jump to last non-blank cell
CTRL + TAB ↔ Cycle between workbooks (Excel files)
Formulas:
F4 ↔ Toggle between relative, mixed & absolute cell references
ALT + = ↔ AutoSum
CTRL + ‘ ↔ Copy contents of cell above
CTRL + ~ ↔ Toggle between formula & cell value
CTRL + : ↔ Enter current time
CTRL + ; ↔ Enter current date
Formatting:
CTRL + 1 ↔ Open the formatting dialog
CTRL + & ↔ Apply outline border to selected cells
CTRL + _ ↔ Remove outline border to selected cells
CTRL + ~ ↔ Apply general number format
CTRL + $ ↔ Apply currency format (2 decimal places)
CTRL + % ↔ Apply % format (0 decimal places)
CTRL + # ↔ Apply date format (Day, Month, Year)
CTRL + ) ↔ Unhide any hidden columns within the selection
CTRL + 9 ↔ Hide Row
CTRL + 0 ↔ Hide Column
CTRL + ( ↔ Unhide any hidden rows within the selection
CTRL + ) ↔ Unhide any hidden columns within the selection
CTRL + D ↔ Fill down from above
CTRL + + ↔ Insert a row
CTRL + – ↔ Delete a row
ALT + Enter ↔ Force a line break while editing a cell (creates a 2nd row of text in the cell)
If you are curious you can check out the full list of Excel shortcuts.
nice tips
LikeLike
Very nice post. I just stumbled upon your blog and wanted to say that I have truly enjoyed browsing
your blog posts. After all I’ll be subscribing to your rss feed and I hope you write again very soon!
LikeLike