Tip Printed from ExcelTip.com

---

Copying & Pasting Cell Content to Thousands of Cells in Excel 2007


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 the keys to select the range A1:A5000.
4. Press to paste.