Adjust column widths quickly by double-clicking or dragging column borders located between column letters. Adjust row height similarly with row borders.
- [Instructor] You can easily adjust the width of columns and the height of rows and nearly always you don't need to go into the menu system. Instead, you can use the boundary between columns or rows to make the changes. In this particular worksheet, called rows and columns, in our workbook 04 Formatting, all of our column widths look pretty reasonable. The actual column width, and occasionally we do care, as I point the mouse on the boundary between columns H and I, hold down the left mouse button, width 10 139 pixels. I'll do the same thing on column G, 119 pixels.
Column F, 119, so on. Now, we can make these all be the same, we can adjust them at any time. The basic way to change a column width is not by way of commands but simply to point to the right-hand boundary of a column, drag it rightward or leftward. I want column H to be a little narrower, maybe. I point to the boundary between column H and I, hold down the left mouse button, drag a little bit to the left, you see what happens. If the cell has numbers in it and you make the column too narrow, we will see those hashtag pound signs in column H.
But the feature that's best serve here, as you work with columns and rows, is to double click a boundary. As soon as I double click the boundary between H and I, I'm readjusting column H to be what we call a best fit. Meaning it will be wide enough to display the widest entry. Now if I later type a long word, for example down here in cell H13, I need it there, Excel will need to make that column wider. There are different times you'll find that happens automatically, but if it doesn't, double click the boundary. We can also take care of multiple columns at the same time.
For whatever reason, maybe for space issues, I want all of these columns from columns B through I, to be wider. They're all highlighted, I can point to any of these boundaries here, hold down the left mouse button, drag it a little bit, and what am I doing? I'm making them all wider, but I'm making them also the exact width. So as I slide over here, and hold down the left mouse button, that's 132 pixels, and the one over here, that's 132 pixels. And another time you might be saying, well, let's make these all be a so-called best fit.
Now that means column H is gonna be wider than column G because it's got a wider number. We see over here. So we can do that as well too. Drag across all of these columns here, double-click any boundary. What does that mean? Make each column be optimum width. Best fit, click click, there we go. So again, without laboring too much on the actual size, this one right here is 112, this one right here is 112, and so is that one, and this one here, that's 131 and so on.
So many times you don't care about the actual pixels, it's just the actual look that you see. And sometimes you'll get a worksheet for other sources where certain columns are showing those hashtags and sometimes you'll see that when you zoom in and out in that lower right-hand corner. That slider bar. Sometimes you'll see- there they are right there, momentarily. And that's no fault of yours, that's just an oddity in Excel. And sometimes you change these to the larger you'll see 'em too, but we're not in this case. So you can easily make the adjustment. We don't have to go to commands. It's usually less important to adjust rows but if for whatever reason you wanted to print this and wanted to allow more white space around the numbers so that they could be annotated, for example, we can drag across, for example rows three, four, five and six.
If we want to make all of these taller, point to any of these boundaries, drag downward, we might make them twice as tall, roughly. Something like that. We can easily make that adjustment. So it has the look of double spacing. We might reconsider and do this for all of these rows. Drag across these, drag to a certain height, see how that looks. Sometimes we'll print it, sometimes not. But we can easily make the adjustments. At a later time we might want to readjust all these, how do we select the entire worksheet? Click in the upper left corner. If I double-click any boundary between rows, automatically Excel adjusts every row to be a best fit height.
Double-click, it happens. Same thing happens with columns as well, too. This data here is actually in cell A1. And so a related feature, although we don't work with it in the same way, is sometimes we want a title to be in multiple cells. This in cell A1. If I double-click the boundary on column A, look what happens. That's not what we intended. I'm gonna undo that, control Z. We can center this across all these columns. I'm gonna highlight all these cells. And here's a button called merge & center.
That essentially turns all these into cell A1. And there is no B1, C1, D1, et cetera. So now, if we were to adjust column A, I'll purposefully make it wider for the moment. Come back and double-click, what happens? So, I think you quickly get the idea. We can easily adjust column widths at any time, we never worry about columns being too wide or too narrow because it's so easy to readjust them. If somehow we got a situation where this is too narrow, that's too wide, suppose a bunch of these are all messed up. What do we do? Click in the upper left corner, double-click a column boundary, Excel ignores the merged cell and adjusts all the others.
So it's an easy feature to work with and indispensable as you work with Excel in different kinds of worksheets.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros