Ask Your Question

How to set ROW Ht.; for WHOLE docu.?

asked 2017-07-28 19:24:27 +0200

abi gravatar image

Tried to find; OPTIONS --------------------- ø Tried to find; HEL,P --------------------- ø

Hope you know ...

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-07-28 23:42:11 +0200

m.a.riosv gravatar image

An option to increase the size, it's change the font for default format, there is a minimum about 10, for less doesn't reduce, but applies for increase the size with one greater.

edit flag offensive delete link more

answered 2017-07-29 10:11:43 +0200

librebel gravatar image

updated 2017-07-29 15:21:32 +0200

Hello @abi,

just select all cells in your Sheet, then right-click on the Row Header and choose the menu item "Row Height...". There you can set the desired height for all cells in the sheet.

EDIT: Here is a solution to set the default height using a Template.

edit flag offensive delete link more


But it's not used for new sheets on the file.

m.a.riosv gravatar imagem.a.riosv ( 2017-07-29 12:28:34 +0200 )edit

This will even work across all the sheets selected (with the help of Shift+Click or Ctrl+Click on sheet tabs) at the time of 'Select All' usage.
Be careful: The multiselection of sheets will also allow "MultySheetClear" and any different kind of "MultiSheetFormatting". You can even enter something in one go into all the equally addressed cells of all the selected sheets.
Quoting @m.a.riosv: "But it's not used for new sheets on the file." I don't understand this.

Lupp gravatar imageLupp ( 2017-07-29 12:31:13 +0200 )edit

Hi @Lupp, click on '+' on the sheets bar navigator, to create a new one.

m.a.riosv gravatar imagem.a.riosv ( 2017-07-29 12:37:14 +0200 )edit

@m.a.riosv: I understand this in the sense: "The row height applied to everything first will not be used like a template property with later inserted / added sheets."

Lupp gravatar imageLupp ( 2017-07-29 12:53:21 +0200 )edit

That's @Lupp.

m.a.riosv gravatar imagem.a.riosv ( 2017-07-29 23:24:34 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-07-28 19:24:27 +0200

Seen: 167 times

Last updated: Jul 29 '17