How do you select a large section of spreadsheet using cell references?

To select a large section of a spreadsheet using cell references, click on the first cell of the desired range, then hold down the Shift key and click on the last cell of the range. Alternatively, you can type the range directly into the Name Box (located next to the formula bar), like "A1:D100," and press Enter. This action will highlight the specified range of cells in the spreadsheet.