#250 Excel: Cliffs Notes Version

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.

Advertisements

3 thoughts on “#250 Excel: Cliffs Notes Version

  1. 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!

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s