Excel Tip – Keyboard shortcuts

The fastest Excel users have one thing in common They rarely use the mouse. Most all actions in Excel can be done with a keyboard shortcut. Here are some of my favorites:

CTRL + HOME — Go to Cell A1

CTRL + END — Goes to the last cell used. 

CTRL+SHIFT + right arrow then down arrow — will select all contiguous cells

CTRL + A –  Selects entire spreadsheet

F4 – Changes cell address to Absolute

CTRL + T – Converts data range to a table

CTRL + E — Flash Fill 

CTRL + ; — Inserts the current date.

Leave a comment

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: