How To Change The Column Width In Excel

http://www.online-tech-tips.com

Excel's filigree-similar advent can seem static at times without the possibility of creating customized interfaces to friction match the needs of the data stored in a worksheet. Although this is true to some extent, Microsoft has built in to Excel the ability to instantly customize column widths and row heights to friction match the size of the data in the cells.

Learn how to use Excel'due south AutoFit feature to automatically alter the size of columns and rows to the size of the data in a worksheet.

Before You lot Alter Column Widths and Row Heights in Excel

In that location are limits to how large and pocket-size yous can brand columns and rows in Excel. Column widths and row heights with a value of nothing are subconscious in an Excel worksheet. This is the equivalent to using the hide column or row characteristic.

Columns can have a maximum width of 255. This number represents the maximum number of characters a column can concur at the standard font size. Changing the font, the font size, and adding other characteristics to the font such as italics and bolding greatly reduce the maximum number of characters a cavalcade can hold. The default size of an Excel column is 8.43, which correlates to 64 pixels.

Rows can have a maximum height of 409. This number represents how many one-seventy seconds of an inch the row tin can agree. The default size of an Excel row is 15, which correlates to 20 pixels or nigh i-fifth of an inch.

Using Excel's AutoFit Feature

Suppose in your Excel worksheet yous have text in the A1 prison cell that extends beyond the 8.43 (64 pixels) default column width. Notice that although the column'due south width cannot contain the length of the text, Excel allows the text to spill over into adjacent columns.

Select Cavalcade A, click on the Abode tab on the Ribbon, and locate a section of the Ribbon nearly all the way to the right labeled Cells. Click on the button titled Format and locate a section of the menu labeled Cell Size. Notice that there are iii options for changing the width of a column.

Cavalcade Width – This option allows you to manually change the width of a column past typing in a number. This option isn't useful considering you tin can more hands accomplish the same thing by simply dragging the cavalcade to your desired size.

AutoFit Column Width – This is the choice we desire. This selection will change the size of the column to a new size depending on the length of the contents of the jail cell in the column that takes up the nigh infinite.

Default Width – This option doesn't actually alter the width of any columns; it simply changes the default width of the columns for a particular worksheet.

On the Format push'southward menu, select AutoFit Column Width and notice that the width of Column A has changed to contain the length of the text in the A1 jail cell.

Unlike column widths, Excel automatically adjusts the height of a row to arrange the height of the text that takes up the almost vertical space in each row. Therefore, the AutoFit Row Height characteristic institute on the Format button is not as useful as the AutoFit Column Width characteristic.

When pasting information into an Excel worksheet, there are times when the row heights exercise not suit automatically. When this happens, text will exist cut off rather than spill over into another row either above or below.

To gear up this, select the row with the cutting-off text and click on Format>AutoFit Row Height. This will force Excel to change the peak of the row to adjust the unusually alpine text.

Using Excel's AutoFit feature yous can automatically modify the width of columns and the elevation of rows in a worksheet to accommodate unlike sized text without having to manually change the width and height values. A real fourth dimension saver, the AutoFit characteristic can besides make data in your worksheet easier to access and read.

This Tech Tip is brought to you by the Business organisation and Engineering Section ... It solutions for today's CPAs. For more than information and to view an annal of previous Tech Tips, please visit us here.

Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to communications@ficpa.org.