From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Modify tables
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Modify tables
- [Instructor] After your tables have been created, you may find that you need to add additional columns or rows to the table. After watching this video, you'll know how to add or remove table rows and columns. You'll know how to configure table style options, and how to insert and configure the total row. Let's jump right into our modify tables document and take a look at our internet orders for quarter one. It looks like the information in columns G and H are not included in our table. To add these two columns, and any new records that have been added, we'll click in the table, go to the table tools design tab and choose resize table. So you can see the marquee around the current table range. We can resize the table in this window just by changing the range references, so change column F to H, and row 50 to 53. Now we also can click the arrow to collapse the resize table window, and reselect the data including the two new columns, and the three new rows below. Either way works just…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.