- 1). Open the Excel file in which you want to copy a cell across the entire spreadsheet. Click the cell you wish to copy.
- 2). Hold the "Ctrl" key, and press "C" to copy the cell.
- 3). Click the first cell in the range to where you wish to copy.
- 4). Hold the "Shift" key, and click the last cell in the range. This highlights all of the cells.
- 5). Hold the "Ctrl" key, and press "V" to paste the copied cell across the entire selection.
previous post