From the course: Learning Excel Desktop (Microsoft 365) (2024)
Join today to access over 24,900 courses taught by industry experts.
Manage rows - Microsoft Excel Tutorial
From the course: Learning Excel Desktop (Microsoft 365) (2024)
Manage rows
- [Instructor] Just as we can manipulate columns to create extra space and make our workbooks more pleasing to the eye and easier to read, we can also manipulate rows to do the same. And that's what we're going to explore in this movie, continuing with our Globe Bank Inc. Projected Revenues workbook, GlobeBankPR0204 if you're catching up. We do have a couple of empty rows. Row two and row eight are currently empty. We did that to create the extra space, but we know it's not good practice. When we went to use AutoSum earlier, for example, it automatically took all of the cells above, including this empty cell, and included it in the formula. We had to make the adjustment. So you can avoid issues like that by removing the blank rows and instead creating taller rows to create space. Let's start with row two. We really don't need it, there's nothing in those cells. You can click anywhere in a row and go up to the ribbon with the home tab selected, click that Delete drop down. Here's where…
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.