Excel Quick Tip: Changing Column Width
November 13, 2007 – 7:37 am
This time of year, many people are beginning to develop their budgets so I thought an Excel Quick Tip might be useful. Getting your spreadsheet to “look right” and also print correctly is often the most difficult part of using Excel. Here is a tip to help you setup your column widths.
If you want to change the widths of several columns, start by selecting the columns you want to change. If you want to change the widths of adjacent columns, just select the first column that you would like to include, hold down the shift key, and click on the last column.. If you want to change the widths of non-adjacent columns, hold down the control key instead of the shift key and click on each column. After all your columns are selected, just drag the width of any of the selected columns and all of the highlighted columns will change to the same width.
I hope Excel Quick Tip will save you time and effort in the future.