Tips.Net > ExcelTips Home > Editing > Shortcut for Selecting a Data Range
Shortcut for Selecting a Data Range
Summary: The easiest way to select a contiguous data range is to use Ctrl+Shift+8. This tip introduces the shortcut and explains how it works. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
The quickest way to select a range of data on your worksheet is to use Ctrl+Shift+8. (This is the same as Ctrl+*.) This selects, using the currently selected cell as the starting point, the contiguous cells that contain data. The selection stops when a blank row or a blank column is reached.
To see how the shortcut works, suppose you have data in the range A1:A325, and more data in the range C1:E190. If you start with cell A7 selected and then press Ctrl+Shift+8, then A1:A325 is selected. (The other data range isn't selected because column B is blank.) If you start with cell D12 selected and press Ctrl+Shift+8, then the range C1:E190 is selected. Again, the selection doesn't extend to column A because column B is blank.
Tip #2531 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Got the Time? If you work with either times or dates in Excel, you really need ExcelTips: Times and Dates. Everything you need to know about slicing, dicing, and generally working with times and dates.
Macros Rock!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site