Excel sheet
Asked by
keerthi sudha
on 2012-05-31
Hi,
when i am entering the data into a cell in Excel, it is continuing in a very lengthy cell.
I want it to be in a precise cell by wrapping it
Plz help me out
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- 2012-05-31
- Last reply:
- 2017-01-10
Tony Pursell (ajpursell) said : | #1 |
Hi,
If you want a large piece of text to be wrapped, you can do that for yourself by breaking it up with line feeds. You do that by inserting Ctrl-Rtn or Ctrl-Enter.
Alternatively, you can do Format > Cells... and on the Alignment tab, under Properties, you can check 'Wrap text automatically'.
With the first method, you will have to adjust the cell height manually, but with the second method, it adjusts automatically.
Hope that helps,
Tony
Can you help with this problem?
Provide an answer of your own, or ask keerthi sudha for more information if necessary.
To post a message you must log in.