How to Automatically Resize Columns in Excel

If you have been using Excel you will have noticed that if you have some text that is too big for a cell that if you type something into the next cell it crops it. You haven't lost anything it is just the cell is too small. You can adjust the column width by clicking and dragging the column header. But the easy way to do this is autofit the column size and it is so easy. Here is this video I show you how to do this and also for multiple columns even if not next to each other.

I also show you how to do this with row heights.

This works the same on both the Windows and Mac version.

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.