• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint