You can this functionality in various ways:
- as you type in data and press Enter, the active cell will always stay within your selected cells and ranges
- create functions that use multiple ranges of cells
- apply the same formatting to multiple areas of your spreadsheet
- enter the same data in multiple areas simultaneously
- Delete data simultaneously in your selected cells and ranges
Highlights
- Select noncontiguous ranges
- Work with data in noncontiguous cells and ranges
- Format and delete data in noncontiguous cells and ranges
- Create functions that use multiple ranges of cells