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:

728x90

7

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin