Excel: Data Form Width Set by Widest Column

ID: Q80487

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:

Close the Data Form.

Select the wide column or columns on the spreadsheet.

From the Format menu, choose Column Width.

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)

REFERENCES

"Microsoft Excel User's Guide," for Macintosh, version 3.0, page 356

Additional query words: 2.20 3.0

Keywords :
Version :
Platform :
Issue type :