Question: how to copy and paste large columns in excel?
Answer: Select 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.