« Bluetooth | Main | Planning Year End Ordering »

Cleaning up out of control Excel spreadsheet cells

I use Excel spreadsheets to manage projects.  Format tool
Sometimes when the spreadsheets get big and the cells have a lot of information in them, they end up with empty space at the top of a cell. I wished for an easy way to clean this up and there is one! Here is how you fix it.

  1. Highlight the column with the messy cells.   
  2. Click on the Format option and a drop down box will appear.   
  3. Click on AutoFit Row Height and each cell in the column will automatically adjust its width.

Below you can see the before and after pictures. If the adjacent cells are bigger than the one you are trying to adjust, it won't get any smaller. But, you can see that this simple command made a big difference.





Excel before


Excal after


Feed You can follow this conversation by subscribing to the comment feed for this post.

Post a comment