In this example three range addresses are combined together to form B2:C4,D6:E8,F10:G12. Type the Range Addresses you want to select, separated by a comma in "Go To" dialog box.
You can select multiple Ranges in same Excel worksheet by keying-in Range addresses separated by a comma in Cell Name box of Formula bar.įor Example : Enter B2:C4,D6:E8,F10:G12 in Cell Name box and press "Enter" key to get multiple selection as below.Ĥ - Enter the Range Addresses separated by a comma in "Go To" dialog box You can watch whether "Add or Remove Selection" mode is enabled from Excel Status bar, as shown below.ģ - Enter the Range Addresses separated by a comma in Cell Name box of Formula bar When you press "Shift" & "F8" keys together, "Add or Remove Selection" mode is enabled. Press "Shift" & "F8" keys together to select multiple Ranges in same worksheet. 2 - Enable "Add or Remove Selection" mode to select multiple Ranges in same worksheet First select a Range and then press and hold "Ctrl" key while selecting next Range in same worksheet. To clear the print area and return to printing the entire spreadsheet: 1. In fact, after this specific print area is declared, Excel will only print this area until this setting is cleared. Now when you print the document, only the selected portion of the spreadsheet will print. To select multiple ranges in same Excel worksheet, use "Ctrl" key. Click Print Area and select Set Print Area. Normally when you select a Range and then click on another cell, first selected Range will be deselected. Click on a cell in one of the corners of the range of cells you wish to select. This feature works the same in all modern versions of Microsoft Excel: 2010, 2013, and 2016.
#Select large area in excel how to#
What is Range in Excel Worksheet and How to form a Range AddressĮxamples of Range Addresses in Excel worksheet 1 - Press and hold "Ctrl" key to select multiple Ranges in same worksheet To select a range of cells in Microsoft Excel, just follow these three steps. Following are the different ways to select many ranges in an Excel worksheet.īefore continuing, please click below links to learn more about Range Addresses. You may select multiple ranges (non-contiguous) in an Excel worksheet. Cells in Excel worksheet Range are contiguous.
0 kommentar(er)
