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

column width

ResolvedVersion 2003

Pat has attended:
Excel Introduction course
Excel Intermediate course

Column width

how do I make all columns automatically fit the width of the contents, please?

RE: column width

Hi Pat

Thank you for asking this question, and sorry we haven't got back to you before now

this question has been asked before so your not alone in this, what you will have to do is highlight all the columns you want to auto fit the text, then when you have done this move your mouse to the separator of any of the columns i.e. between B and C.

You should have a double headed arrow at that point just double click your mouse and that should do the trick

Please let me know if there is anything else

If this has answered your query then I would request you to please mark the question as Resolved!! If not and you have a specific question related to this then please click Reply or post it as a new question and we should be able to answer that!!

Many Thanks

Mark East
MOUS Master Instructor

Mark@stl-training.co.uk

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

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.