Adjust column-widths quickly and easily without using menu commands. Click and drag across multiple column letters and then double click any column boundary (between column letters) to make each column be wide enough to display any data in the column. Similar approaches apply for adjusting row heights.
- [Voiceover] As we look at this worksheet called Column Widths, you can see that many of the column widths are not appropriate. Column A is not wide enough, same thing with Column C. You might be familiar with what we're seeing in Columns D, E, and G. Whenever a column contains numbers and is not wide enough, You're likely to see pound signs in at least some of the cells. We can adjust these quickly and easily without menu commands. Let's suppose for the moment that all we wanted to adjust would be columns D, E, and G. We can click and drag across the column letters, D and E, and then if we want to select another column, hold down the command key.
I'm doing that as I click Column G. Now, to adjust these columns widths so that they are so-called best fit, I can either double-click on the right hand edge of Column G where the letters are, or the right hand edge of column E or D. Double-click, all those columns are readjusted. Now, I'm going to undo that with command Z and possibly take care of all these columns at once throughout the entire worksheet. Or maybe I just care about this particular section here. I can double-click any column boundary. For example, this one, and various column widths are adjusted.
There certainly are times when you say, "Well I want this column to be narrower." Farther down the list are some departments that are wider than this, but let's say much of the time I don't care about that. I'll make this a little bit narrower. I've got a pretty clear idea of what's going on as I scroll up and down for example. Occasionally, I might want to manually make that wider. So we can always do that with any given column. Now, scrolling off to the right is a different set of data. You might want to work with it a little bit differently. The January through June entries do not go over a thousand.
Column T, the total entry does. If I drag across these columns just here, I might want all of these to be the same width. Maybe I'm not sure how wide I want these to be. I'll click and drag any column boundary, it could be this one. Maybe make that a bit larger, for the moment at least. But what I've done is made all of these columns be exactly the same width. Now, most of the time you don't really care how wide a column is in terms of its pixels. And so if you point to the right hand edge of any column and hold down the mouse button, you'll see, for example, this is 67 pixels.
If I double-click right here, and notice that all of the columns are still currently selected, as I double-click, each of these is likely to be the same size. Holding down the mouse button here, 50 pixels, and here too, 50 pixels. If I were to select all of these and double-click a boundary Column T is going to be a bit wider. That's all that's happening there. So Column T here, 59 pixels, the other columns to the left are all going to be 50 pixels. And again, most of the time you don't care about the pixels, but there are those times when you say, "I want all these to be of a certain width." Now, if we really want all of these columns here to be exactly the same width, we can drag Column T, maybe just a little bit wider for the moment, and all these are now 61 pixels wide.
Drag it back a little bit to the left, and see what's happening there. So we've got different needs at different times. You don't have to worry about finding any of this in the menu system. We can do similar things with row heights, although you are much, much less likely to need that feature. If, for whatever reason, you want a little more breathing space, so to speak, between these rows, we can click in the upper left hand corner, point to any row boundary, and make it a bit taller. Now, Row 1 appears to be taller because, possibly some text differences, font changes, or wrapped text somewhere, but if we make this a bit taller, we're making all the rows taller because I clicked in the upper left corner to select the entire worksheet.
So you might want that look for a while, and maybe you'll print it too. But at a later time you might say, "Let's put everything back to normal." Click in the upper left corner to select the entire worksheet, double-click any row boundary between the numbers. And we're back to a so-called normal view. So, you've got complete control over adjusting column widths and row heights, and it's something you'll learn to adjust to quickly and after a while you don't even give it a second thought. When columns don't look wide enough you can quickly adjust them. Notice in this part of the worksheet over in Column M, I haven't adjusted Column M.
For the moment, this text information is spilling over into Column M, at least visually. It doesn't hurt 'cause there's no data there, but on the other hand, at some point we might say, "Well, let's readjust that." Double-click the boundary between M and N, and there we are. It's probably what most of us would do there. And once again, changing my mind, perhaps saying, "I want all these columns here to be a best fit." Drag across, double-click a boundary, Columns N through S are likely to be exactly the same, Column T, a bit wider, because of the data that's in it.
So, an easy feature to work with and to adjust, adjusting column widths and occasionally, row heights.
The course then dives into data entry and editing techniques, formatting and drag-and-drop tricks, keyboard shortcuts for working with formulas, data management strategies, and chart tricks. Short on time? Make sure to check out the "Ten Tiny Tips" chapter for a quick productivity boost.
- Entering today's date or time instantly
- Converting formulas to values with a simple right-drag
- Undoing and redoing with keyboard commands
- Creating split screens fast
- Navigating in workbooks quickly
- Selecting noncontiguous ranges
- Entering data more efficiently
- Applying formatting with keyboard shortcuts
- Accelerating copying and moving data with drag and drop
- Creating formulas rapidly
- Using database techniques to work with Excel data
- Working with charts, shapes, and linked images