Jump to content

Managing column widths


Recommended Posts

Managing column widths

One challenge that perpetually faces all Excel users is how to fit as much information as possible on the printed page. Here are three techniques to help you manage your column widths.

The eyeball method: If you think a column is too wide or too narrow, click on the right edge of the column heading (the gray bar at the top of the column) and drag to the left to make the column narrower or drag to the right to make the column wider.

The automatic method: If you want Excel to adjust the column width based on the longest entry in the column, double-click on the right edge of the column heading.

Note that if the column contains a particularly long text entry, the column could become so wide that you can no longer see the right edge of the column heading. Make that column heading visible again by reducing the Zoom setting, say from 100 percent to 50 percent or so. This brings the column heading back into view, where you can click-and-drag on it to make the column narrower.

The menu method: You can use this approach to set the width for a single column or multiple columns at once. Select the column or columns, then go to Format | Column | Width. Enter the appropriate width and click OK.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...