Tag Archives: excel

Keep formatting in Excel when copying/pasting from web page

Question from B.G.: Sorry to bother. How can I export and keep the integrity of the web page table columns? When I copy and paste to excel, it puts all data to 1 row. Answer:  Good question! Please find the steps below: Instructions In your web browser window showing the table/report, press CTRL+A (to select all) Then press CTRL+C (to copy) Switch to a blank spreadsheet in Excel, press CTRL+V (to paste) That should result in a nice separate set of

[SOLVED] Can’t paste because the Copy area and paste area… [EXCEL]

Q. I cannot determine what is causing the following error: Can you help me determine what causes this, I am working with some large Excel spreadsheets and it is driving me mad. Thank you. -Shelly A.  Hi Shelly! Since you are dealing with large Excel spreadsheets, the problem is likely that you are near the one million row count and that the pasted cells push you over the limit. It is absurd that Excel throws the wrong error message for this