Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2003

Bridget has attended:
Excel Introduction course

Excel

How does one automatically expand the width of a column to fit the contents, if one doesn't want to wrap text?

RE: Excel

Hello Bridget

Thank you for your question and welcome to the forum.

To automatically expand the width of a column so it fits the widest piece of data within the column, position your cursor so that it is directly on top of the divider between dark grey box showing the letter of the column that you wish to expand, and the next grey box at the top of the column to the right of the column you're expanding. Then double-click the left mouse button.

I hope this helps.

Kind regards
Amanda

Wed 3 Jun 2009: Automatically marked as resolved.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.