LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 129
Default Row Height-Auto Adjust to Content?

Hi everyone,

Is it possible to set Excel Rows to automatically adjust to the content in
any rows?
I'm working on a significantly large excel sheet and prefer to print only
one sheet of paper across; however I'm trying to squeeze a couple more
columns in there that might overflow to the next sheet across. I'm thinking
of shrinking the columns' width of some columns to compromise the space for
couple columns that I'm adding. But as you know, some Addresses are short
and some are long. I don't want to increase the height of all rows when I
decrease the columns width, and I also don't want to set the formatting to
"Shrink to Fit" as this will cause some text to be shrink down to the size
that is unreadable.

Is there a way to set the rows height to auto-adjust to the content? Such
that the height will increase when the text is overflowing to 2 rows or 3
rows and so on? I know "Wrap Text" will wrap the text in the column width
defined by user but the height won't increase.

Help please!

Neon520
 
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
auto adjust column widths and row height DebC Excel Discussion (Misc queries) 1 November 24th 09 03:17 PM
Auto-adjust row height does not work correctly Eric_NY Excel Discussion (Misc queries) 2 August 28th 09 08:36 PM
Row height to auto-adjust for wrapped text CW Excel Discussion (Misc queries) 4 December 20th 06 05:00 PM
How do I auto adjust row height on merged columns w/wrapped text? ExcelBee Excel Discussion (Misc queries) 2 November 17th 06 04:48 AM
Auto-adjust cell height to accommodate contained text. PETBerkeley Excel Discussion (Misc queries) 5 October 28th 05 05:50 PM


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

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

About Us

"It's about Microsoft Excel"