answersLogoWhite

0

It depends, if the next cell is blank that the cell will extend normally to allow the text to be displayed.

However, if the cell is occupied it will display something along the lines of ##### to indicate the column width is not sufficient; the solution to which are as follows:

  1. Extend the column width by placing your arrow on the line next to the letter until your cursor changes and click and drag to the desired width.
  2. Set the cell to 'wrapped text' by right clicking on the cell and going to format, and extend the row height using the same method as mentioned in 1. but with the row instead of the column.
  3. Reduce the length of the text in the cell
  4. Reduce the font size of the text in the cell
User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

When Excel automatically sets the width of a column based on the widest entry in the column is called what?

Autofit is the facility that allows a column to set its width at the widest entry in the column.


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 many column width will remain if you do not assign a format to a cell or cells in a column characters?

The column width will remain set at its default width, which is usually 12.43 pixels. If you type something longer than that, it will appear to spill out into the neighbouring cell if it is empty, or appear truncated if there is something in the next cell.


What does the width adjustment command do in excel?

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


When inserting a column what determines a column width?

New columns will always be inserted set at the default width. You normally select an existing column before inserting a new one, but no matter what the width of the selected column is, the new column will still be the default width when it is inserted.


What is column width?

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


How do you adjust the column width and or row height of many cells at once in Excel 2010?

Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.Select more that one row or column and then set the width or height in the normal manner. It will affect every row or column that is selected. You can drag out the height or width of the first selected row or column to do it.


How do you change the width of the column?

You can change the width of a column several ways. The two most common methods are:From the format menu, select column width and set for the width of your choice.Click on the line to the right of the cell heading (letter at the top of the cell) and drag the column border line to the width of your choice.


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

row height = 15 column width = 8.43


When you decrease a column wight to the column is hidden?

You can hide a column by reducing its width.


If you want to increase or decrease column width significantly you can right-click a column heading and then use the command on the shortcut menu to change the columns width?

This is a true statement, but it is not a guestion.


Can you hide a column by setting the column width to zero?

Yes you can.