CTRL + *: Highlight All Your Data

If you want to highlight all your data quickly, you need to press the Excel asterisk shortcut: CTRL + *

This will highlight all your data (regardless if you have blank cells) including column names, saving you lots of precious time.

HELPFUL RESOURCE:

If you like this Excel tip, please share it

Facebook

Twitter

Google+

CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+LTo un-filter, you need to press this shortcut again. I use this shortcut all the time 🙂

CTRL + SHIFT + END: Select All Your Data When you have lots of data on a workbook and it is spread out over the page with some blank columns or rows, a great way to select and highlight all your data is to use the CTRL+SHIFT+END keyboard shortcut.This will extend the selection to the last used cell on the worksheet ...

CTRL + 1: Format Cells A keyboard shortcut that I use almost every day is the CTRL + 1 shortcut.This bring up the Format Cells dialogue box and from in there you can choose to format your Numbers, Dates, Alignment, Font, Border, Fill & Protection.Helpful Resource:

CTRL + D/R: Copy Down/Right A quick way to copy whatever is directly above or to the left of you is to press CTRL + D to copy DOWN or CTRL + R to copy RIGHT.Helpful Resource: