Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto adjust column widths and row height | Excel Discussion (Misc queries) | |||
Auto-adjust row height does not work correctly | Excel Discussion (Misc queries) | |||
Row height to auto-adjust for wrapped text | Excel Discussion (Misc queries) | |||
How do I auto adjust row height on merged columns w/wrapped text? | Excel Discussion (Misc queries) | |||
Auto-adjust cell height to accommodate contained text. | Excel Discussion (Misc queries) |