Tip Printed from ExcelTip.com

---

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.