The next topic that I want to get into is a common question that I get since I make Excel trainings. This deals with changing the width of a column and the height of a row. this shows up in various questions that I get for many different reasons.
One I just want to get in there make it look a little more presentable.
The other reason I get this question quite a bit of is because data starts to get cut off it. The column is too narrow, or the row is just too low right. It is just it is now high enough the height is not presenting all the data.
For example, as below:
Why that happens is because it is a numeric value. Remember that dates are numeric to Excel and it is just too narrow for the month of March.
So all I need to do here is move up to E column, I move my cursor between E and F, I move my cursor, I get that kind of two headed arrow, I left click and drag.
This will allow me to adjust the width of that column, you will see if I narrow it too much I go back to those pound symbols by narrow way too much then I am starting to get pound symbols instead of all those numeric values.
I just drag that out just to give it a little bit more space and accommodate for the size of those values.
Now if it is not numeric you do not get the ### symbols if it is too narrow, but it just gets cut off.
You do the same thing with Row. If I want to increase the height or decrease the height, I can go in between two rows five and six, I will grab that line and just drag it to increase or decrease the height of that row.
That can be super useful not just for revealing more content, but if you want to increase the height and color the background to do some formatting commands.
It can also happen if you end up wrapping tags or have a big paragraph of text and you need to increase the width and height of that cell.
Now, I am going to give you one more tip, actually two more tips.
I love tips, I love shortcuts. Something else you can do if you want to automatically adjust a column. I want to adjust the column with, and I want it to find the largest value in that column and adjusted to that.
I just wanted to auto fit if I move my cursor in between the two columns again get that double headed arrow once again. I will just double click, and it will auto fit to the largest value in that column.
Something else you can do. Love this one, and it is a question I get asked all the time “How can I just multiple columns?”.
If I want to adjust all three months and the total and the percent (C column to G column), let us just draw more and then exclude the bills that, I am going to highlight C column to G, I am going to go to column between E and F or D and E and I am going to left click and drag.
I am just adjusting the D column but as soon as I let go it will adjust all of them. if I double click in between one of them it will auto fit every column, love it. you want it to be uniform consistent highlight all the columns readjust and adjust each column, and the same will be true with rows you highlight multiple rows in there. You drag it one along and it will adjust all of them for you.
Another way to do this. Right-click on header of column then select Column width.. command.
Then set exact column width you want in the Column width box.
You do same with Row Height, Right click on header of row, select Row height.. command.
Then set row height in the row height box.
Again, modifying your existing worksheet, making sure that your data is presentable that you can read.
You are not getting those ### symbols where your numbers, you are not cutting off values.
Try it out get some practice with it, a single column, multiple columns double quick for an auto fit, adjust your columns.