How to Select a Large Range of Cells in Excel Mac?

Posted in  mac | 2022-03-20

How to Easily Select a Block of Cells in Excel

Click the first cell in the range you want to select. Scroll your sheet until you find the last cell in the range you want to select. Hold down your Shift key , and then click that cell. All the cells in the range are now selected.

How do I Select a Large Range of Cells in Excel Without Scrolling?

Click into the cell in the upper left corner of the range.
Click into the Name Box and type the cell in the lower right corner of the range.
Press SHIFT + Enter.
Excel will select the entire range.

How do you Quickly Select a Range of Cells in Excel Mac?

Hold down CTRL (or if using a Mac COMMAND) and SHIFT on the keyboard and then press the down arrow key. This will select all of the cells in the range as long as there are no empty cells in the range.

How do you Select a Large Group of Cells in Excel?

Click on a cell to select it. Or use the keyboard to navigate to it and select it.
To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.
To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Select Large Range in Excel