How to Paste Special HTML in Microsoft Excel 2003

The spreadsheet software of today is not just for financial projections anymore. Many web designers will user spreadsheet software to make comments on HTML code, or share suggestion code changes with other developers. Spreadsheet software applications like Excel allow for users to even paste this code into spreadsheets and add notes about it. This feature is easier than ever for designers to communicate about code and make notes or changes to existing code before making them to a live website.

Things You'll Need

• Microsoft Excel 2003
• HTML code

Instructions

1. Create the desired HTML that you wish to paste special into Excel with.

2. Copy the HTML code. You can easily copy the HTML by highlighting it all and pressing the hotkeys “CTRL-A” and then by pressing the hotkeys “CTRL-C.”

3. Access the "Paste special" menu. To access this menu, you will need to scroll to the “Edit” tab and select “Paste Special.”

4. Set the paste special options. Under the paste special properties menu, in the “As” box, you should left-click on “HTML” to select the format.

5. Paste special the HTML into Excel. Now click on the “OK” button to paste special HTML into Excel.

Tips & Warnings

• Pasting special with HTML is a great way to share existing code with other designers and make any amendments or changes to the code before making it live on the Internet.

• Pasting HTML special will not change the HTML, but the code will not work in Excel either. Instead, you can just see and edit it.