ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Auto fit text in cells (https://www.excelbanter.com/excel-worksheet-functions/124948-auto-fit-text-cells.html)

Loren

Auto fit text in cells
 
I have merged cells E thru S with a row height of 12.75 and have the "Wrap
Text" check box checked. If I put in more text than will fit from left to
right is there anyway the row height will automatically grow to show all my
text? I want to protect my spreadsheet and manually increasing my row height
is not allowed once the protection is activated.
--
Loren

Sanjay Shah

Auto fit text in cells
 
Only way I know is to select row and go through the menu options:
Format
Row
Autofit

--
Sanjay

"Loren" wrote:

I have merged cells E thru S with a row height of 12.75 and have the "Wrap
Text" check box checked. If I put in more text than will fit from left to
right is there anyway the row height will automatically grow to show all my
text? I want to protect my spreadsheet and manually increasing my row height
is not allowed once the protection is activated.
--
Loren



All times are GMT +1. The time now is 10:55 PM.

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