Column Widths and Why
- 02:41
Explaining why setting up column widths at the beginning is important.
Glossary
Excel SetupTranscript
I'd like to start working on my model. So I scroll down to where we've got the labels started. However, it doesn't look great. We've got this really wide column A, but then B has really wide wordy labels and they're spilling over the column and we need to set up our columns. You might think that this is a bit of a strange thing to start with, but column widths really is the beginning of a best practice model. Let's start in column A. Column A, we typically have as very, very narrow, and we just put the major headings into column A. Now, the reason we do this is it helps us to scroll up and down through our model. We can scroll of course, using the scroll bar on the right hand side. If you've got a scroll wheel or a touch pad, you can use that. But if you've got maybe 1,000 rows or even 10,000 rows, using the scroll can take a long time to get to the bottom. So we use column A and we call it the navigation column or the elevator column. What I'm going to do is I'm going to press and hold the control button, and then I can press the up arrow and I can jump through the major headings. If I press control and then the down arrow, it allows me to jump down through the headings. Let's go one more. Let's see if there's anything extra and there is, that's allowed me to jump down to row 134 really quickly. Let's jump back up again with control arrows. So column A, I want to make that nice and skinny, so I'm just going to take my mouse, take it up to the top between the A and the B, and I can see it changes to this double arrow. I'm going to click hold and then drag and make column A nice and skinny.
Next up, column B, I can see that the wordy labels, they're overlapping the columns at the moment, so again, I could just click and drag and make it a bit wider than the widest label at the moment. There is another trick you can do. You can go up between the B and C, wait for it to change, and I could then double click and it chooses the widest label and makes the column that wide. However, in this case, it's going to make it as wide as this label in row 14, so let's just try it. If I double click, yikes, column B is now really, really wide, so I'll press Ctrl Z or Control Z just to bring it back to what I did earlier thereafter. Columns C, D, E, F, et cetera. We typically have them relatively narrow and all the same width. That allows us to put some numbers in there and maybe some headings. So columns all set up.