ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to "auto fit" (https://www.excelbanter.com/excel-worksheet-functions/98748-how-auto-fit.html)

Mo don't know

How to "auto fit"
 
I have a spread sheet with many about 6 columns. The first column has much
less text (per cell) than the second. When I'm done, I collapse the column
with more text per cell and am left with large cells with little text it
them. I have to manually adjust all the cells to bring up the bottom wall
and make it fit nicely around the text. Is there anyway that I could avoid
this? Please help, I am not very computer savvy, but this would save me
hours at work! Thanks

Gord Dibben

How to "auto fit"
 
Mo

Row heights and Column widths are the properties of the row and column.

You cannot autofit individual cells to bring up the bottom wall.


Gord Dibben MS Excel MVP

On Tue, 11 Jul 2006 15:25:01 -0700, Mo don't know <Mo don't
wrote:

I have a spread sheet with many about 6 columns. The first column has much
less text (per cell) than the second. When I'm done, I collapse the column
with more text per cell and am left with large cells with little text it
them. I have to manually adjust all the cells to bring up the bottom wall
and make it fit nicely around the text. Is there anyway that I could avoid
this? Please help, I am not very computer savvy, but this would save me
hours at work! Thanks




All times are GMT +1. The time now is 08:23 AM.

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