From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Join today to access over 24,700 courses taught by industry experts.
Modify tables - Microsoft Excel Tutorial
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Modify tables
- [Instructor] After we have created our table, we may want to modify the table styles and look at some of the other options we have available to us. In this video, I'll show you how to insert additional columns and rows to an existing table. We'll look at column banding and row banding, how to emphasize the first and last columns, and how to insert and configure total rows. Let's jump right into our document and modify our table. I'm working in the 04 02 Modify Tables workbook, and the first thing that I would like to do is insert right after the ship mode column, who we use to ship the item, shipping company. So I'll click after the column where I want to insert the new column, right-click, go to insert, and here is my new column. Notice that the formatting was picked up perfectly, and I am now ready to go ahead and add my header, shipping company, and ready to start inserting the information. I can insert a row in the…
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.