» Copying & Pasting Cell Content to Thousands of Cells
To copy & paste cell content to thousands of cells:
1. Select and copy cell A1.
2. Type a cell address in the Name box, for this example, type A5000.
3. Press Shift+Enter to select the cells from A1:A5000.
4. To paste, press Enter.