![]() 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 select multiple ranges in same Excel worksheet, use "Ctrl" key. ![]() Normally when you select a Range and then click on another cell, first selected Range will be deselected. 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 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |