We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel help please
Seaxwyn
Posts: 4,896 Forumite
in Techie Stuff
Help for an Excel numpty please!
I'm working on a spreadsheet that has text in some of the boxes. Sometimes the text flows nicely, so the lines break where necessary and all the text is visible. Other times, the lines don't break so you can only see the first few lines, though all the text is there. How do I make it flow so it's all visible?
also - is there a way I can go in and edit the text in a cell? As if I try to make changes, it deletes the whole box.
Thanks to anyone who can help!
I'm working on a spreadsheet that has text in some of the boxes. Sometimes the text flows nicely, so the lines break where necessary and all the text is visible. Other times, the lines don't break so you can only see the first few lines, though all the text is there. How do I make it flow so it's all visible?
also - is there a way I can go in and edit the text in a cell? As if I try to make changes, it deletes the whole box.
Thanks to anyone who can help!
Total debt: 1 January 2007 £[strike]49,387.79[/strike] 1 January 2012 £[STRIKE]19,312.85[/STRIKE] 1 August 2012 £11,517.62
0
Comments
-
You can change to cell properties to 'wrap text' and then you can double click the cell resize bit below the row number on the left to auto resize the cell.
To edit a cell: Click on the cell you want to edit and press F2. I think double clicking the cell will achieve the same.0 -
Brilliant! Thank you so much!Total debt: 1 January 2007 £[strike]49,387.79[/strike] 1 January 2012 £[STRIKE]19,312.85[/STRIKE] 1 August 2012 £11,517.620
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards