From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Unlock the full course today
Join today to access over 24,700 courses taught by industry experts.
Insert and delete columns, rows, and cells - Microsoft Excel Tutorial
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Insert and delete columns, rows, and cells
- [Instructor] When you're developing your worksheets, sometimes we forget to add a column, and we need to go in after the fact, and insert another column or a row or even a cell. So after watching this video, you'll know how to quickly go in, and insert additional columns, rows and cells into your worksheet. Let's jump right into our workbook, which is the 0303 insert and delete workbook. We want to continue on with our travel expenses so it's just not showing the quarter one travel expenses, but we want to go ahead and insert three more columns so we can continue on with April, May and June. Now here's a quick and easy way to do that. I know I want three columns. So I'm going to start with E, which is where I want it to go in before. So E, F and G. So I have selected three columns, and if I insert columns, it's going to put three in for me. So that's a nice tip that you can hold onto. I'll…
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 options5m 28s
-
(Locked)
Fill cells by using AutoFill4m 20s
-
(Locked)
Insert and delete columns, rows, and cells3m 26s
-
(Locked)
Format cells and ranges5m 28s
-
(Locked)
Generate random and sequential data using Functions4m 55s
-
(Locked)
Apply styles to cells and ranges7m 49s
-
(Locked)
Define and reference named ranges3m 39s
-
(Locked)
Insert sparklines3m 28s
-
(Locked)
Summarize data visually with built-in conditional formatting3m 24s
-
(Locked)
Challenge: Manage data, cells, and ranges32s
-
(Locked)
Solution: Manage data, cells, and ranges4m 46s
-
-
-
-
-