Tech Tip #42

Exel offers many different ways to adjust each column and row width to suit your needs.

AutoFit Column Width - Adjust the width to automatically fit the data included in each column.

• Click the column you want to modify ( to select multiply columns, press and hold Ctrl while clicking each column).   

        2003 EXCEL Users - Click the format drop down menu in the cells group and select       

        "Autofit Column Width."     

        2007 EXCEL Users -  Click the Home tab, "Format", and "AutoFit Column Width."

• Click the column you want adjusted and drag the vertical bar between any two columns to the required width.  You can also double click that same vertical bar, and the column will be automatically fitted to the widest entry in the column.  The same method works to adjust row heights.

You can also highlight all columns and double left click on the last column vertical bar, and all of your columns will be increased to the required width based on the data entered into the cell.  

THIS IS A GREAT WAY TO SAVE TIME IN YOUR SPREADSHEET FORMATTING!