answersLogoWhite

0

Use AUTOFIT, which finds the widest value in a column and sets the width to that. It is found in the Format menu, under Column. It can also be done by putting the mouse between the column headings for two columns until you get a double-headed arrow, and then double clicking.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

How do you Change the with?

How do you change the width of a column in excel


What does the width adjustment command do in excel?

The column width command adjusts the width of a column or selected range of columns.


What is default value for height and column width in Excel?

row height = 15 column width = 8.43


What is the column width in Microsoft 2007 excel?

Variable


What is the column width in Microsoft 2003 excel?

Variable


What is column width?

Column width is what it says -- how wide the column is.


What does a spilt double arrow allow you to do when positioned between two column or row heading?

It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.It enables you to change the width of a column, or the height of a row. It changes the width of the column to the left or the height of the row above.


How do you change the width of column f so that the contents automatically fit within the column in excel?

Double click on between the heading for column F and column G. When you put the cursor there, it will change to a bar with arrows to the left and to the right.


What is the best column in Excel?

There is no best column in Excel. All columns are the same. If you are referring to the best fit, then that is based on the widest entry in a column being used to set the width of the column.


When excel automatically st the width of a column what is it called?

close fit


The defult width of a cell in a Excel what is character?

The actual column width depends on the font you select, but the default width is 8.43.


What does The split double arrow mouse pointer in Excel?

It is the result of moving the mouse pointer to the boundary between column heading A and column heading B, or between any neighbouring column headings. Once it is visible, it is possible to change the column widths. The column to the left is always the one that will have its width changed.