From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Insert and delete columns, rows, and cells
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Insert and delete columns, rows, and cells
- [Instructor] When we're developing our worksheets in our workbooks, a lot of times, we need to insert, or delete columns, rows, and cells. After watching this video, you'll know how to insert columns, delete rows, and how you can insert or delete cells within your data. Let's jump right into our Insert Delete workbook. On our Products table, I would like to insert two columns, just to the right of Product. Now there's a couple of ways that I can do that. I can simply select Column C and D, because I want to insert two columns, I'll select two columns and that's the number that will be inserted. Right-click on the selection and go to Insert and see how quickly those were inserted? Now we also can select a column, and on my Home ribbon, click on Insert, and I can insert sheet columns, and in it goes. Now what if I want to delete a column? I've added one too many here, so this is a great chance for me to show you how easy it is to remove it. With Column E selected, I'll right-click and…
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
-
-
-
-
-
Paste data using special paste options6m 28s
-
(Locked)
Fills cells by using AutoFill4m 16s
-
(Locked)
Insert and delete columns, rows, and cells3m 15s
-
(Locked)
Format cells and ranges5m 39s
-
(Locked)
Apply styles to cells and ranges6m 44s
-
(Locked)
Define and reference named ranges5m 18s
-
(Locked)
Insert sparklines5m 35s
-
(Locked)
Summarize data visually with built-in conditional formatting5m 3s
-
(Locked)
Challenge: Manage data, cells, and ranges27s
-
(Locked)
Solution: Manage data, cells, and ranges4m 23s
-
-
-
-
-
-