Change column width in Datasheet view
- Right-click the column header, and click Column Width.
- In the Column Width dialog box, type a number between 1 and 255.
Notes
- If you specify 0 as the width, the column will appear hidden.
- You can also drag the boundary on the right side of the column header until the column is the width you want. To size a column so that the contents of each cell fit in a single line, move the cursor to the right boundary of the column header. When the resizing cursor appears, double-click the boundary line.