Microsoft KB Archive/80487

{|
 * width="100%"|

Excel: Data Form Width Set by Widest Column

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0, 5.0
 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

-

SUMMARY
In Microsoft Excel, the width of the Data Form is dependent on the widest column in the database. If a column is too large to display alongside the Data Form buttons and field names, part of the Data Form will be off the screen.

MORE INFORMATION
To have the entire Data Form appear on the screen, column widths must be within certain limits that vary with monitor size.

If part of the Data Form is off the screen:


 * 1) Close the Data Form.
 * 2) Select the wide column or columns on the spreadsheet.
 * 3) From the Format menu, choose Column Width.
 * 4) Enter a smaller value in the Column Width box and choose the OK button.

The buttons provided in the Data Form can be accessed by using the keyboard if the buttons are off the screen. The following keyboard commands are equivalent to clicking the Data Form buttons:

  Keyboard Command     Button ---     --

COMMAND+W   New COMMAND+D   Delete COMMAND+R   Restore COMMAND+P   Find Previous COMMAND+N   Find Next COMMAND+C   Criteria (Enter Criteria) COMMAND+F   Form (Return to Data Form) COMMAND+L   Close (Data Form Window)