From the course: Excel 2019 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Rows and Columns
- [Instructor] It's not uncommon that you need to add a new row, or rows, within a worksheet, and also the same thing with columns. In this list on a worksheet called Insert-Delete in the workbook 05 - Layout, we need to make some room for a new record that we're gonna put in in column A. I'm gonna put it above row 5. Now, as we work with columns and rows, much of the time we do not need to go through the standard menu. The shortcut menu technique, the right mouse button, is going to be very helpful. If I want a new row above row 5, I can simply right-click row 5, and Insert, and a new row's inserted. Now, what if I had not been paying attention to this particular worksheet, and I scroll to the right here, I've disrupted the data off to the right. So that wasn't a great idea. I'll undo that with ctrl + z. But what can we do in a case like this? If we simply highlight the cells from A5 over to I5 in this example here, if we right-click within the highlighted area, and choose Insert…
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.