From the course: Excel: Setting Up a Database (Microsoft 365)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Expand tables automatically and add totals
From the course: Excel: Setting Up a Database (Microsoft 365)
Expand tables automatically and add totals
- [Instructor] When we work with tables in Excel, the whole issue of working with rows and columns is a bit different. First of all, do notice this fact about tables. Anytime we add information in the column just to the right of the table or on the row just below, that information immediately becomes part of the table, even with just a heading. So in cell L1, I'm going to put in a new heading here, New Salary eventually we'll have formulas in this column, but as I type this and press Enter, what happens? That column is part of the table. Now format doesn't look so good, so I'll simply take the cell to its left and with the right mouse button drag an edge rightward into cell L1 copy here as formats only. Now I want to put in a new record above row seven here, and if this were standard, non-table Excel here I would highlight these cells, right click and insert. Not difficult, anything like that. We can do the same thing here,…
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.
Contents
-
-
-
-
-
(Locked)
Convert data into tables for enhanced visual and content control5m 13s
-
(Locked)
Use the Design tab to control table formatting4m 8s
-
(Locked)
Expand tables automatically and add totals5m 5s
-
(Locked)
Work with formulas in tables4m 36s
-
(Locked)
Use slicers to facilitate table filtering5m 14s
-
(Locked)
-