Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there an "auto fill" formula? punter Excel Discussion (Misc queries) 1 December 9th 05 12:40 AM
How do I get a column to "auto fill" in a pivot table? punter Excel Discussion (Misc queries) 2 December 8th 05 08:49 PM
Is there an "auto tab" option in excel? Shar Excel Worksheet Functions 2 November 22nd 05 09:38 PM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"