From the course: Excel Essential Training (Microsoft 365)
Join today to access over 23,200 courses taught by industry experts.
Rows and columns: Insert, delete, hide, and unhide
From the course: Excel Essential Training (Microsoft 365)
Rows and columns: Insert, delete, hide, and unhide
- When you work with lists of data in Excel there are times when you want to insert new rows, take out rows at times, of course, same thing with columns. And we certainly do have some commands available on the home tab up in the ribbon but these tend to be lengthier. It's likely to be faster and easier simply by using the right mouse button and that means a shortcut menu. Now, I'm about to add a new name here, Aaron Adams. I want to put it right above David Adams here. So I'm right clicking row four and I click insert. It's not followed by the word row but that's what has happened. Now, maybe I'm a bit forgetful here. I've got other data off to the right and I've disrupted that. Now, that's not a huge problem at least I haven't deleted data but that's not really what I wanted to do here. So I'll undo that with control Z and this time simply highlight the cells from columns A through column J and then right clicking…
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.