When you create a new workbook in Excel, by default, all the columns are the same size widths and the rows are the same height, but you can quickly and easily change these.

I'm in cell E4 and I want to change the width and the height. I'm going to start by using my mouse. If I go up between the E and the F, you'll notice my mouse changes and I click and just drag to the right.

I could do exactly the same thing with the row height. So between row four and five, my mouse changes. I click and I drag down. To increase the row height, I can do exactly the same thing using the ribbon. If I go into the home ribbon and then go to the format section, the top one here is row height. Now if I click into this, it tells me that the current height is 30.

I might want to set that to a different number. I'm going to go with 20. Great. The height has now changed.

I can do exactly the same four column width. So again, in my home ribbon under format, I click into column width.

I see it's currently 15.33. I'm gonna change that to 20 as well, and that has now been updated. Alternatively, instead of setting the height, I can get Excel to find the auto height or auto width for the cell. I'm looking at, imagine that I've made row four a bit too big and I want Excel to find the correct height for me. Well, if I go between four and five with my mouse, I see my mouse changes, but instead of clicking and dragging, I can just double click and Excel does it for me. Similarly, if I go up between column E and F where my mouse changes double click and Excel has auto fitted the width for me.

If I want to do this using the ribbon, let's just make the column and the row a bit bigger. Again, if I go up to my home ribbon format and select Autofit Row height, I can see row four has adjusted and I can do the same thing for the column width. Click on format, and then autofit column width. Now you'll notice that when I do the width, Excel does it for the cell that I'm in. That's great for this cell, but unfortunately I can't see any of the numbers underneath. So to avoid this, what I can do is I can select the cells I would like to get the auto width of, then go to format autofit column width and Excel has adjusted to the widest of those cells. The problem you can get is if you do autofit everywhere, your table can look a bit inconsistent and disorganized. So if for example, I do autofit on name, then I select Autofit on 83. I've now got columns that are all different widths and it does look a little bit inconsistent. So instead what I can do is I can select cells in each column. So here I've got 1, 2, 3, 4, 5, 6, 7 columns.

I can go to format, I can go to column width and I can set a consistent width for every column. So let's try 10 and we can see that is now looking a little bit neater.