What is the fastest way to copy large amounts of data in Excel?
Copying to Very Large RangesSelect cell A3.Press Ctrl+C to copy its contents to the Clipboard.Click once in the Name box, above column A. (Before you click, the Name box contains "A3," which is the cell you just copied.)Type C3:C55000 and press Enter. The range is selected.Press Ctrl+V.Furthermore, ...