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 columns/rows.
Select All, Copy/Paste Results
Please let me know if you encounter any issues. Have a great day!
–J.D.
Top Search Terms:
- copy and paste in excel keeping format (6)
- excel keep formatting when pasting (2)
- why is my paste formatting turned off in web excel (1)
- formatting excel sheets from copying web (1)
- formatting error when copying text from web page (1)
- excel keep formatting from webpage (1)
- excel how to copy past page and keep format (1)
- excel - retain format on web page (1)
- copy spreadsheet from webpage to excel formatting (1)
- copy paste format from webpage to excel (1)