| View previous topic :: View next topic |
| Author |
Message |
jcupper
Blue Pill
Joined: May 06, 2008
Posts: 2
|
 Posted: Tue May 06, 2008 10:05 am Post subject: Auto Adjust Spreadsheet Row Height |
|
| Is there a way to set up a specific group of cells in a spreadsheet to allow the height to adjust to fit the amount of text entered? |
|
| Back to top |
|
 |
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Tue May 06, 2008 10:43 am Post subject: |
|
Select the cells you want to modify the height.
Go to Format > Row > Optimal Height…
Enter the value you need in the Add field and click OK.
Jacqueline |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Tue May 06, 2008 11:57 am Post subject: |
|
Select the cells you want to 'autosize' and right-click / ctrl-click on one of them and choose Format Cells. On the Alignment tab, check 'Wrap text automatically' and 'Hyphenation active'. This will wrap the text and set the cell height accordingly, but it only works if the text's horizontal alignment is Justified.
Otherwise, you can select the relevant rows, move the mouse pointer over the row headers until it changes to a horizontal line with a double-headed arrow through it, and then double-click - this is the same as doing auto-width on columns.
I hope some of this is useful...
- padmavyuha |
|
| Back to top |
|
|
jcupper
Blue Pill
Joined: May 06, 2008
Posts: 2
|
| Posted: Tue May 06, 2008 12:50 pm Post subject: |
|
| Thanks. That did the trick! |
|
| Back to top |
|
|
LJ-Bettona
Keymaker
Joined: Jan 23, 2008
Posts: 98
Location: United States
|
| Posted: Fri May 16, 2008 1:53 am Post subject: |
|
Yoxi wrote:
| Quote: | | Select the cells you want to 'autosize' and right-click / ctrl-click on one of them and choose Format Cells. On the Alignment tab, check 'Wrap text automatically' and 'Hyphenation active'. This will wrap the text and set the cell height accordingly, but it only works if the text's horizontal alignment is Justified. |
I just tried that on a complicated cell entry. Yes, the hyphenation worked brilliantly. And it works on left alignment as well as justified. But the cell height did not re-adjust automatically not even when the alignment was justified.
Just information, but I would like to know how to do this for the whole sheet.
I have discovered that the default height is related to the font size, but for me, it's too close. It needs a fraction more space around the numbers so I would like to be able to re-set the default row height.
Any ideas, anyone? |
|
| Back to top |
|
|
jgd
Agent Smith
Joined: Feb 27, 2005
Posts: 1531
Location: France
|
| Posted: Fri May 16, 2008 4:34 am Post subject: |
|
Open a new Calc document. Select all. Then go to
Format > Row > Height…
In the dialog that appears, change the height value as you wish. Click OK.
Save your document as template: File > Templates > Save…
Give your template a name and click OK.
Then go to File > Templates > Organize…
Select your new template and click on Commands.
Choose Set as Default Template. Click Close.
Afterwards every time you'll open a new spreadsheet, you'll get the wished height for the rows.
Jacqueline |
|
| Back to top |
|
|
|
