Ubuntu
openoffice.org package

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
For:
Ubuntu openoffice.org Edit question
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.