Ready to watch this entire course?
Become a member and get unlimited access to the entire skills library of over 4,900 courses, including more video2brain and personalized recommendations.Start Your Free Trial Now
- View Offline
- Why data management is important in AutoCAD
- Designing attributes and storing attribute data
- Using fields to display object properties
- Extracting data from AutoCAD send to Microsoft Excel
- Creating tables
- Formatting table cells and styles
- Editing table cells and using formulas
Skill Level Intermediate
In this lesson, you will learn how to unlock table cells and edit table cell data. You will also resize table columns and add a new column. Open the Office 12 project file and Zoom In to this upper table which was extracted directly from attribute beta. Click on this cell and you'll see a tiny padlock appear next to the cursor, that means this cell comes directly from the data extraction. This is the attribute tag name.
So, we can't change it, by default. However, I'd to change this to the full word manufacturer. And I don't want it to appear in all caps either. So, in order to edit this information. I need to right-click and choose Locking > Unlocked. Then I can go a head and double-click in the Cell to edit that data. Highlight, the remainder of the word, and in lowercase type the rest of the word, Manufacturer, press Enter.
And it's input however, the word is too long to fit in the cell, so the row automatically got taller. We'll fix that in a minute. Next, let's change model and Price to title case. Double-click on the model Cell, and you'll see that it too is locked. Hold down Shift and click on the Adjacent Cell, so that you select both of them at the same time. Then right-click and choose Locking > Unlocked.
Double-click on cell D2, Highlight this part of the word, and then type that again in lowercase, double-click on the Adjacent Cell, and fix it as well. Now, I'm going to click on the table, but instead of clicking in a cell, I'm going to be careful to click directly on one of its lines. This puts you in a different editing mode.
Here I can click this grip and drag the column and make it wider. However, I don't want to snap to the next grip, so I need to be careful and come down to here and Turn Off running object snap. And then I'll click over here someplace to make that particular cell wider. But I did that unfortunately at the expense of this adjacent column. I'm going to change the column width with this script, and make the whole table a bit wider. Then I have some more space to play with.
I can then move this over and make everything fit. Double-click on this Top Cell and type Furniture Schedule, Enter. I also notice that the information in the cells is at the top, let's see if we can change that. I'll select this cell, hold down Shift then select this cell that selects this whole area from cell A3 all the way down to cell E5. Then up here, on the Cell Styles panel, let's change this from top center to middle center and then press the Esc key.
Let's also create a New Column over here, click cell E2. Right click, and choose Columns > Insert Right. Double-click on this cell F2, and type Totals. Let's add another row as well, but to do so I'm going to move the whole table up a bit.
Use the Move Command, select the Table, Enter, and then just move it up an arbitrary distance. Select this cell, right-click on the Five Header, and choose Insert Row below, and then click outside the table. So in this lesson, you learned how to edit a table generated automatically from extracted data. By unlocking selected cells, you were able to edit their contents. In addition, you learned how to resize columns, and added a new column, and a new row.