Layer Tips and Create Tables Linking To an Excel Spreadsheet
You can create a printable layer list from
the new layer palette by selecting everything (CTRL+A), copying (CTRL+C) and
then opening a new spreadsheet and pasting (CTRL+V).
Next tip: After pasting the data to spreadsheet. One easy way to do this is to copy the data from Excel. Select all of these items and then copy them to the Windows clipboard. Make sure the spreadsheet file is saved. See Image 01 below.
 |
| Image 01 |
Next, go back to
AutoCAD. Then, in AutoCAD in the Clipboard panel on the Home ribbon tab, I'll
select Paste Special. AutoCAD displays the Paste Special dialog. See image 02
below.
 |
| Image 02 |
In this dialog,
I'll select Paste Link to paste the contents of the clipboard as a link. Notice
that when I select Paste Link, I have a choice of pasting as a Microsoft Excel
Worksheet or as AutoCAD Entities. Choose AutoCAD entities then Ok. See image 03
below.
 |
| Image 03 |
As you hover the table there has an image
look like a chain and padlock, these properties of the table have been linked
and locked. To do this, click the cell; look up in the ribbon tab under “Table
Cell” find the Cell Locking tab. You
will find the option of this, choose “Unlocked” and now you’re ready for
editing.
Thanks for reading. Have a thoughts to share? Any comments are appreciated here. Next tutorial tips more on AutoCAD table editing and modifying.
Thanks for reading. Have a thoughts to share? Any comments are appreciated here. Next tutorial tips more on AutoCAD table editing and modifying.
