Having survived the DOS era I find myself reluctant to give up keyboarding, and one of my favorite keyboard functions in Excel is the F8 Extend key.
By moving the cell pointer to the starting cell, you can press F8 to enable Extend (indicated on the status bar by the letters EXT or Extend Selection). Using the mouse, you can click on the final cell of a contiguous range to extend the selection highlight. All keyboard cursor keys can also be used to extend the selection.
For extremely large ranges you can do the following:
Figure 1. Extend mode is engaged.
Figure 2. The Go To dialog box.
For non-contiguous ranges the key combination of Shift+F8 turns on Add. Using the mouse you can click and drag each required block of ranges.
To cancel either Extend or Add press the Esc key or press F8 or Shift+F8 again.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12106) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Creating Selections.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Need to concatenate the contents in a number of columns so that it appears in a single column? Excel has no intrinsic way ...
Discover MoreHave you ever copied information from one worksheet to another, only to have the information you paste not look the way ...
Discover MoreIf you hide the first rows of a worksheet, you may have a hard time getting those rows visible again. Here's a simple way ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-05-22 13:17:06
Anne
I love this tip. Thanks, Alan.
2017-05-21 21:20:49
Don White
Thanks For this tip
Its Brilliant, and I never knew this!!
2017-05-21 08:33:39
Ofer Rotshtein
Hi,
I use the Shift to sellect area and Ctrl to add another area to multipal area.
Ofer
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments