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.
CTRL + *: Highlight All Your Data
About The Author
Great! I learn a new shortcut. I was using Ctrl+space till now. I will use this too.
Dhruv
-
Hi Dhruv,
We have a lot more Excel shortcuts that are fun to use!
Regards,
Bryan
Great tips, but can you put the Mac command equivalents? Thanks
-
Hey Lee,
You can find all the Mac shortcut commands here: https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccdCheers,
John
