column width

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Column width

Column width

resolvedResolved · Low Priority · Version 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:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips


Server loaded in 0.11 secs.