AutoCAD 2010/2011/2012

Distinguished Contributor
Posts: 193
Registered: ‎05-06-2005
Message 1 of 5 (1,772 Views)
Accepted Solution

Force Table Font

1772 Views, 4 Replies
09-17-2012 01:59 PM

1.Set Tablestyle to desired, table font is defined in tablestyle as an .shx font.

2. Insert a new table using copyclipped Excel data, using Paste Special...Autocad Entities.


No matter what font I choose in Excel, Autocad inisists on overriding tablestyle font and formatting font as True Type inherited from Excel data. Have cleared all formatting in Excel. Since I cannot perform multiple cell font re-formats (you really need to fix that) and match cell style also cannot be used to paste multiple formats, it seems it is impossible to strip the true-type formatting out of a large table. This is infuriating.

Any suggestions?

*Expert Elite*
Posts: 21,870
Registered: ‎11-06-2003
Message 2 of 5 (1,760 Views)

Re: Force Table Font

09-18-2012 06:27 AM in reply to: Myoula

AutoCAD still does not offer a "strip formatting" option when pasting content from other programs like MSoffice products do, nor does it override them by default, and that remains the key issue to your need.

Dean Saadallah Blog | Facebook | Google+ | Twitter | PINS
Active Member
Posts: 9
Registered: ‎08-30-2010
Message 3 of 5 (1,692 Views)

Re: Force Table Font

10-15-2012 09:40 AM in reply to: pendean

I feel your pain...


Sadly I encountered the same issue.

My crude but effective work-around was to "Paset Special"

Apply the table styles to the various cells (Title, Header, Data).

Grip adjust the table to fit my sizing criteria.

...Here's where it gets ugly:

Copy the table in the drawing.

Explode the table.

Explode the table again.

Now tou should have "dumb" individual AutoCAD objects that can have all their properties adjusted.

Not elegant nor very flexible, but functional.


Best Regards


Distinguished Contributor
Posts: 193
Registered: ‎05-06-2005
Message 4 of 5 (1,680 Views)

Re: Force Table Font

10-15-2012 12:05 PM in reply to: knickers

Have discovered another way to do this, slightly less clunky.

1. Start new table

2. Create named data link

3. MAKE SURE YOU CHECK THE RADIO BUTTON INDICATING THAT YOU WISH TO REMOVE ALL FORMATTING FROM THE EXCEL SPREADSHEET (SEE ATTACHED). This is the only chance you have to do this - you cannot come back later on and choose this!

3. Once table is created, break the data link and you will have a "dumb" table again with the font set at the defined font for the tablestyle, even if it is an .shx font.

4. This only works for R2012 SP1 or later! It is not docmumented.

5. If you are using Vault, it is important to break the data link AND REMOVE ALL REFRENCES TO THE DATA LINK IN DATA LINK MANAGER - for some reason Vault chokes when trying to resolve file relationships with data links and xrefs for Autocad drawings if file paths are not relative (and even then it is iffy). The only way the data link will be correctly resolved in Vault is if the dwg file containing the link is in the same folder at the same level in the directory structure as the linked to file. This is especially problematic when attempting to move files in Vault - if both are not moved at the same time the resolution bombs.

Active Contributor
Posts: 27
Registered: ‎04-27-2004
Message 5 of 5 (1,544 Views)

Re: Force Table Font

01-29-2013 03:13 PM in reply to: Myoula

Thanks Myoula,


I have fought with this issue for a long time.  I really appreciate you for posting this tip.


My solution had been to go cell by cell overriding the font and color.  This is much better.



You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community

Connect with AutoCAD