LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default 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?
 
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
Making a cell show relevant data IoHeFy Excel Discussion (Misc queries) 1 August 25th 06 12:32 PM
How do I resize a cell in Excel to display two lines of data alanb Excel Discussion (Misc queries) 2 December 14th 05 05:45 PM
Auto-adjust cell height to accommodate contained text. PETBerkeley Excel Discussion (Misc queries) 5 October 28th 05 05:50 PM
How do change the amortization of loan template to accommodate pa. Rennie M Excel Discussion (Misc queries) 1 March 3rd 05 07:11 PM
Is there a way of making data imput in to a cell mandatory before. TerryM Excel Worksheet Functions 0 February 15th 05 11:25 AM


All times are GMT +1. The time now is 07:57 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"