From the course: Learning Excel 2016

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Managing rows and columns

Managing rows and columns

From the course: Learning Excel 2016

Start my 1-month free trial

Managing rows and columns

“

- Another way to change the look of your worksheets here in Excel, maybe make them easier to read, is to modify rows and columns. There may be occasions when you need to insert rows and columns, or maybe remove rows and columns, or change the column widths and row heights. That's what we're going to do in this movie with our Landon Hotel's revenue sheet we've been building. And if you need to get caught up, just open up RH_Revenus0204. You'll have what I have. Let's start with column A because the width of column A was changed for us when we added a date format that was a little bit wider than the one we see here. So if we want to change the width of a column, there are a number of different options. The easiest way, if you want to do it visually, is to go to the separator between columns A and B. You'll notice your mouse pointer turn into a double-sided arrow pointing left and right. That means you can now click and drag to increase the width or decrease the width by going left. I…

Contents