Excel: Data Form Width Set by Widest Column

• 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.

   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