- Open a table, query, or form in Datasheet view (Datasheet view: A view that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).
- Do one or both of the following:
Resize a column
Do one of the following:
To resize a column to a specific width, position the pointer on the right edge of the column you want to resize, as shown in the illustration, and drag until the column is the desired size.
To size a column to fit its data, double-click the right edge of the column heading.
Note You can't undo changes to the width of columns using the Undo command on the Edit menu. To undo changes, close the datasheet, and then click No to All when asked if you want to save changes to the layout of the datasheet. This will also undo any other layout changes you have made.