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

text excel

ResolvedVersion 2003

Katharine has attended:
Word Advanced course
Excel Intermediate course

Text in excel

How can you get the row to expand as you write text?

RE: text in excel

Dear Katherine

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

This is not possible to do from the existing settings and options. In Word Table you are allowed to do this but in Excel when you enter data in cells you can adjust the column width by taking your mouse on the right hand side of the grey area of the column heading. In Word table you can adjust the width of your column from any of the cells.

I am not sure but there may be a way of doing this by VBA method where you will require knowledge and experience of VBA Programming.

I hope this has answered your query.

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 post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

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.1 secs.