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

excel wrap text entire

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel wrap text in entire document

Excel wrap text in entire document

ResolvedVersion 365

Mirella has attended:
Excel Introduction course

Excel wrap text in entire document

I have to use excel to write specifications. As there are templates, often the newly entered text does not show as the cell is cut. How do I wrap text on a document. I have been trying control A, and then pressing wrap text icon which does not do it.
What is the correct method, please?

Edited on Tue 17 Jan 2023, 14:22

RE: Excel wrap text in entire document

Hi Mirella,

Thank you for the forum question.

Well you are using the right method. I have just done it myself. I added a lot of text to a table. I selected all the cells with text an pressed wrap text and all cells in my selection wrapped the text.

I do not know why this method is not working for you.

I can have a look at your file if you send it to:

info@stl-training.co.uk

Please write in the topic that the Excel file is for me.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Excel wrap text in entire document

Hi Mirella,

I have received your file thank you.

Can I please ask you to let me know where you cannot get it to work.

Which worksheet please and also please which cell.

Also try just to select one cell where you cannot get it to work and press Wrap Text (do not use Ctrl A), and see if this is working

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 18 Jan 2024: Automatically marked as resolved.

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

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