Pinterest Pixel

CTRL + SHIFT + END: Select All Your Data

When you have lots of data on a workbook and it is spread out over the page... read more

John Michaloudis
Posted on

Overview

CTRL + SHIFT + END: Select All Your Data | MyExcelOnline CTRL + SHIFT + END: Select All Your Data | MyExcelOnline

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: Select All Your Data | MyExcelOnline
HELPFUL RESOURCE:

728x90

If you like this Excel tip, please share it
CTRL + SHIFT + END: Select All Your Data | MyExcelOnline CTRL + SHIFT + END: Select All Your Data | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  CTRL + *: Highlight All Your Data

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...