ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Autofit Row height or Column Width does not work (https://www.excelbanter.com/excel-discussion-misc-queries/49852-autofit-row-height-column-width-does-not-work.html)

Gunjani

Autofit Row height or Column Width does not work
 
Hi,

Does anyone know why either of my Row or Column Autofit selection (in
Format)does not work. I have to individually set all the row heights
manually.

Any suggestions. Thanks

Gunjani

JVDM

Try to highlight the entire sheet and then drag out any column, align left
and up in the format row and column by auto sorting and that should do it. If
this doesnt fix it sorry...

"Gunjani" wrote:

Hi,

Does anyone know why either of my Row or Column Autofit selection (in
Format)does not work. I have to individually set all the row heights
manually.

Any suggestions. Thanks

Gunjani


Ron de Bruin

Hi Gunjani

Do you have merged cells ?


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Gunjani" wrote in message m...
Hi,

Does anyone know why either of my Row or Column Autofit selection (in
Format)does not work. I have to individually set all the row heights
manually.

Any suggestions. Thanks

Gunjani





All times are GMT +1. The time now is 02:45 AM.

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