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).

Ctrl  Shift  End

HELPFUL RESOURCE:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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 + SHIFT + ARROWS: Move/Highlight Cells If you want to quickly move to the last cell of your table/data you can press CTRL + ↔ ↕.If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT + ↔ ↕.Helpful Resource:
CTRL + -/+: Insert or Delete Rows and Columns in E... One of my favourite Excel keyboard shortcut and one that I use hundreds of times per week is the insert or delete rows and columns.All you have to do is select the whole row or column with your mouse and then press the following:CTRL + - to delete or CTRL + + to insert ...
CTRL + BACKSPACE: Go Back to the Active Cell Say that you click in cell A4 within your Excel worksheet and then you scroll all the way down to the bottom of the page to check on a number in row 20,187.The quickest way to get back to your active cell in A4 is to press the CTRL + BACKSPACE on your keyboard!Watch below...