Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply ...

Excel uses the current cell as the top-left anchor cell and you enter the bottom-right anchor cell (or vice versa). Excel will select everything in between, including the two anchor cells.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

Select the cell range to paste the cells into with the Range function and Select method, making sure the range selected represents the destination cells.

Click the upper-left cell in the range with the border you want to copy. Drag your cursor to the range's lower-right cell, selecting the entire range. Click "Home" on Excel's menu bar.