Although there are other HTML makers available, and other methods of posting a sample table, MrExcel recommends that you use the MrExcel HTML Maker. This HTML Maker was custom built for these forums by Richard Schollar.
Click here to download the MrExcel HTML Maker.
Instructions follow below, however, for further reading and examples see this thread.
- Extract the MrExcel HTML Maker addin (.xla) from the compressed folder. You may need to download an extraction program such as WinZip.
- Locate the Addin’s folder on your computer. If you are uncertain where it is, in Excel invoke the Addin’s dialog in Excel and click ‘Browse’. Note the default folder path.
- Save the addin to the Addin’s folder.
- Go to excel, invoke the Addin's dialog and locate the addin in the list. If it is not there then click browse and locate the addin. Place a check-mark beside the addin, if not already checked.
- Once installed you will notice a new menu called ‘MrExcelHTML’. This appears in the worksheet menu bar for Excel versions 2003 and earlier, or within the ‘Add-Ins’ tab in Excel 2007 and more recent versions.
Before you copy any table to a forum post, consider which of the default options you want to apply. On the MrExcelHtml menu, expand ‘Set Default Options’.
- All Formulas – this option will generate a separate table showing every formula within each formula cell within the selected table.
- First Cell Only – this option will generate a separate table showing the formula in the first cell that has a formula within the selected table.
- First Cell In Each Column – this option will generate a separate table showing the formula in the first cell in each column that has formula within the selected table.
- No Formulas – no formula table is generated.
- User Defined Selection – this option will generate a table based on the pre-selected range, but allows you to choose which formula cells to display in the formula table.
<hr>Using the MrExcel HTML Maker:
1. Highlight the table range in your excel worksheet that you want to display.
2. Go to the MrExceHtml menu.
3. If you are happy to proceed with your default option, click ‘Generate Html (use Default)’. If you want to use a different option then expand ‘Generate Html (specify option)’ and choose from one of the options listed above.
4. The HTML Maker will generate the HTML and place it in your clipboard. Return to your forum post and paste it into the editor.
5. Finish typing your question and hit ‘Submit’.