ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can you get various row heights to hold in a spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/140171-how-can-you-get-various-row-heights-hold-spreadsheet.html)

Peg

How can you get various row heights to hold in a spreadsheet?
 
There are times a "wrap" note is includes in the spreadsheet which makes the
row need to be larger. I have tried pulling it down show all of the note
appears. I have tried setting a size for row height. Neither works -- as I
work with the spreadsheet and go to print it, the size will change and cover
up part of the notes.

r

How can you get various row heights to hold in a spreadsheet?
 
hi
select the cell you want to type the text in
go to format menue and select "Cells"

go to the tap Alignment. you will find three sections in blue

go to section two "Text Control" and check the box "wrap text"

click ok and start typing... the cell will get larger as you type

"Peg" wrote:

There are times a "wrap" note is includes in the spreadsheet which makes the
row need to be larger. I have tried pulling it down show all of the note
appears. I have tried setting a size for row height. Neither works -- as I
work with the spreadsheet and go to print it, the size will change and cover
up part of the notes.



All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com