Saturday 5 May 2012

Auto Adjust Column Width


Auto adjusting column width is easy, all you have to do is to select the columns that you want to adjust and then double click on the right border of the column.

This is how you do it:


Auto Adjust Column Width



















- First select the columns that you want to auto adjust.
- Double click the line between column B and C




Auto Adjust Column Width



















There you go!



Sometimes you see this...


Auto Adjust Column Width






















These are actually numbers that are too long to be displayed in the cell.
All you have to do is select column A and then go to the number tab below home tab and change the format.

Auto Adjust Column Width


For instance, if you choose Number, it will look like this:

Auto Adjust Column Width








No comments:

Post a Comment