Video:How to Change Column Widths in Excelwith Nicholas J. Saccomanno
Changing the column width in Excel can reveal data you might have thought was missing and help format the information you need on a spreadsheet. Watch this About.com video to learn several ways to change the column widths in excel.See Transcript
Transcript:How to Change Column Widths in Excel
Hello. This is Nicholas J. Saccomanno for About.com and today we’ll take a look at how to change column widths in Excel.
Revealing Information in Excel Columns
From time to time your Excel worksheets may display a funny set of characters that look like this- #####. These hash marks don’t indicate a problem with your formula, it just means your column isn’t wide enough to show the data.
Adjusting the Column Width
The easiest way to adjust the column width is to locate the divide bar between column letters and then move the double headed arrow to resize the column. Left click, hold and drag to resize the column. Or alternatively, double-click the double headed arrow to resize the columns to the largest entry in that column.
Finally, you can adjust multiple columns at once by selecting the first column, hold down the Shift key, and then select the last column in a range you would like to resize. Left click hold and drag the divider bar to adjust all the columns at once. With any of these simple moves, you can easily change column widths in Excel.
Thanks for watching! For more information, you can visit About.com.