|
June 2008 - Excel Column Widths
|
Do you spend a lot of time beautifying Excel spreadsheets after you have entered your data into them? There is a quick and easy way to automatically have Excel adjust the width of all the columns that contain data in them and it takes only three mouse clicks to do it!
The secret to this tip is to enter all your data first or at least get your column headings in place and formatted. After you have that completed, highlight the entire spreadsheet by clicking one time on the square in the upper left hand corner of your spreadsheet – above row 1 and to the left of column A. Then place your mouse cursor between any two columns – it doesn’t matter which two. Your mouse cursor will change its appearance something that looks like a single bar in between to outward pointing arrows – when that happens you are in the correct place. When you see that cursor, simply double-click your mouse. Any columns containing data will automatically be widened to the first the longest piece of data in that column.
You can repeat the steps above any time you would like to readjust your column widths!
And that’s a quick and simply way to adjusting your column widths, so…
Give It A Try!
If you would like a printable version of this tip, click here.
|
|
|
|