Modifying the Datasheet

After you format data in the datasheet, you might need to change the column widths to fit the data. If you see ##### in a cell , it means there is not enough room in the column to display the data. You need to increase the column width to display the data. If you need to change one column, you can use the mouse to quickly change the column width. If you want to uniformly change several columns to the same column width, you can use the Column Width command on the Format menu.

Change the Width of a Column

• To increase or decrease the width of a column, position the pointer on the vertical line to the right of the column heading, and then drag the pointer until the column is the correct width.

• To adjust a datasheet column to display the widest data entered (also known as Best Fit), position the pointer on the line to the right of the column heading, and then double-click to adjust the column width.

  If a series of number signs (#) appears in the datasheet cell, it means the cell is not wide enough to display the entire contents of the cell. Widen the column to view the data in that cell.

  

Did You Know?

You can switch the data series around . Change the data series to display by row or column. Click the Data menu, and then click Series In Row or Series In Column.

Enter a Precise Column Width

Click a cell in the column you want to format.

Click the Format menu, and then click Column Width.

Enter a new column width.

Click OK.

Did You Know?

You can switch the data series around . Change the data series to display by row or column. Click the Data menu, and then click Series In Row or Series In Column.

See Also

See " Entering and Formatting Graph Data " on page 154 for information on working with data in a datasheet.