<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
When pasting a block of HTML into Excel, it sometimes displays the actual HTML (what was pasted) but other times, it displays what the HTML codes for.<br />
<br />
<b>What accounts for the difference in how it's displayed?</b><br />
<br />
<b>Is there a setting in Excel to control which of the two forms is displayed?</b><br />
<br />
Thanks
</div>
</div>


Hello,

When pasting a block of HTML into Excel, it sometimes displays the actual HTML (what was pasted) but other times, it displays what the HTML codes for.

What accounts for the difference in how it's displayed?

Is there a setting in Excel to control which of the two forms is displayed?

Thanks

Options for pasting HTML into Excel

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.