Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.