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 (lower-right corner).
HELPFUL RESOURCE:
Post Reviews
THANK YOU!
This simple setting saved me so much frustration!!
Great Help
Thank You for doing so much
Absolutely brilliant.
Simple and easy to remember. Helps a ton and makes excel a lot less of a hassle.
Thanks
Array formula
Array formula make my work easy.I mean time saving.
Informative
I was trying to do this from last 20 min’s but this post has just save the time