Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
making a cell resize itself to accommodate data
I have an Excel spreadsheet with a cell that I'd like to make, by
default, the size of two ordinary cells. I can insert a new row underneath it and then merge that new row with the row I want to make larger but if I do that the cell no longer resizes itself to accommodate data. Some of the existing rows are the size of two or so cells (in terms of height) but, as right clicking on them and going to the Format Cells... option on the resultant menu shows, they're not the result of two merged cells - they're just one cell whose height has been increased. And when you insert data, the cell resizes to accommodate the data much an HTML element whose width or height have not been explcitely specified. That's what I'd like to do but I can't figure out how. Any ideas? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
making a cell resize itself to accommodate data
Merged cells will wrap text but not RowAutofit to accomodate data.
If you MUST use merged cells you will need VBA event code to autofit the rows with merged cells. See google search thread for code by Greg Wilson. Watch out for word wrap in the URL which all one line. http://groups.google.com/group/micro...1c160cbeb27874 Gord Dibben MS Excel MVP On Wed, 4 Nov 2009 15:31:37 -0800 (PST), yawnmoth wrote: I have an Excel spreadsheet with a cell that I'd like to make, by default, the size of two ordinary cells. I can insert a new row underneath it and then merge that new row with the row I want to make larger but if I do that the cell no longer resizes itself to accommodate data. Some of the existing rows are the size of two or so cells (in terms of height) but, as right clicking on them and going to the Format Cells... option on the resultant menu shows, they're not the result of two merged cells - they're just one cell whose height has been increased. And when you insert data, the cell resizes to accommodate the data much an HTML element whose width or height have not been explcitely specified. That's what I'd like to do but I can't figure out how. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a cell show relevant data | Excel Discussion (Misc queries) | |||
How do I resize a cell in Excel to display two lines of data | Excel Discussion (Misc queries) | |||
Auto-adjust cell height to accommodate contained text. | Excel Discussion (Misc queries) | |||
How do change the amortization of loan template to accommodate pa. | Excel Discussion (Misc queries) | |||
Is there a way of making data imput in to a cell mandatory before. | Excel Worksheet Functions |