Creating a Symbols Legend in AutoCAD

AutoCAD Table with a block inserted in a cell

I assume you are familiar with the technique of creating a table in AutoCAD using an Excel spreadsheet to copy the range in Excel then PASTESPEC in AutoCAD. What may be frustrating is getting AutoCAD to match the font of what you have chosen to use in Excel. I want to use the Simplex font in AutoCAD but Excel always sends Calibri font to the clipboard no matter how the cell appears to be formatted in Excel. The technique I document below will solve that font problem.

For those of you who are familiar with my frustration and want a quick answer. Modify the Normal style in Excel.

For those who want a detailed “How To” process I documented it using a mind map found in the link below.