If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cell formatting
is there a way to take an area of about 10 rows and change the cell height to
0.1 so that there are now 100 rows in the original area? |
#2
|
|||
|
|||
cell formatting
Highlight your rows, right click and change the row-height, whether or not
this gets 100 to fit on your page has to do with your display though. -- -John Please rate when your question is answered to help us and others know what is helpful. "Tom" wrote: is there a way to take an area of about 10 rows and change the cell height to 0.1 so that there are now 100 rows in the original area? |
#3
|
|||
|
|||
cell formatting
If I right click on a row title and select Row Height from the popup menu, I
see that my row heights are set at 14.1 (some units, I will no bother with right now). If I select 100 rows; right click the row header and again select Row Height I could set the row height for these rows to 1.41. Now 100 rows occupy the space that 10 rows used before. However, they are so small I cannot read anything in them. But I must have misinterpreted your question. Tell us again what you want to do. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tom" wrote in message ... is there a way to take an area of about 10 rows and change the cell height to 0.1 so that there are now 100 rows in the original area? |
#4
|
|||
|
|||
cell formatting
is there a way to take an area of about 10 rows and change the
cell height to 0.1 so that there are now 100 rows in the original area? You wouldn't change the cell height to 0.1, you would take the current cell height of a single cell (which I'm guessing is the same for all rows) and multiply that height by 0.01 in order to get the height each cell needs to be in order that 100 rows of them would fit in the area that 10 rows now occupy. John gave you a method to do this with in his posting to this thread. My question, though, is why are you doing this? I mean, the rows will be so short that you won't be able to see anything in them. Rick |
#5
|
|||
|
|||
cell formatting
I guess thats what i am asking, but when u get that small the rows disappear.
I dont think I'll be able to do what I actually want to do. Thanks though "Bernard Liengme" wrote: If I right click on a row title and select Row Height from the popup menu, I see that my row heights are set at 14.1 (some units, I will no bother with right now). If I select 100 rows; right click the row header and again select Row Height I could set the row height for these rows to 1.41. Now 100 rows occupy the space that 10 rows used before. However, they are so small I cannot read anything in them. But I must have misinterpreted your question. Tell us again what you want to do. best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Tom" wrote in message ... is there a way to take an area of about 10 rows and change the cell height to 0.1 so that there are now 100 rows in the original area? |
#6
|
|||
|
|||
cell formatting
is there a way to take an area of about 10 rows and change the
cell height to 0.1 so that there are now 100 rows in the original area? You wouldn't change the cell height to 0.1, you would take the current cell height of a single cell (which I'm guessing is the same for all rows) and multiply that height by 0.01 in order to get the height each cell needs to Although from your follow up post to Bernard, you no longer need this, I figured I'd correct my posting anyway... the 0.01 above should have been 0.1 to meet the conditions you set in your message. Rick be in order that 100 rows of them would fit in the area that 10 rows now occupy. John gave you a method to do this with in his posting to this thread. My question, though, is why are you doing this? I mean, the rows will be so short that you won't be able to see anything in them. Rick |
Thread Tools | |
Display Modes | |
|
|