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.

Published by ajigou

Accounting Professor that loves technology

Leave a comment