why a fixed number of rows?

B

Bucky

A related question to another post: Why does a worksheet have a fixed
number of rows (and columns)?

1. Why can't it be dynamically sized? In Word, I start off with 1 page,
and if I keep adding lines, it just automatically gives me more room.
Why not the same for Excel?

2. If there is a good reason for not being dynamically sized, then at
least they could pretend that it is dynamically sized. What I mean by
this is that internally, it uses fixed rows and columns. But the GUI
only shows the used range.
 
S

Suzette

It is just designed that way so you can see the whole thing. The rows that
aren't being used are not using up storage space. They aren't really there,
it just shows them all. It is the way it's displayed on the screen. It is
the same as if you only used two lines in Word but it shows the entire page.
 
R

ring4569

Suzettewrote:
The rows that.

I am not sure if you understood what i meant, but i know that was not
it.
 
B

Bill Sharpe

Bucky said:
A related question to another post: Why does a worksheet have a fixed
number of rows (and columns)?

1. Why can't it be dynamically sized? In Word, I start off with 1 page,
and if I keep adding lines, it just automatically gives me more room.
Why not the same for Excel?

2. If there is a good reason for not being dynamically sized, then at
least they could pretend that it is dynamically sized. What I mean by
this is that internally, it uses fixed rows and columns. But the GUI
only shows the used range.
Click to expand...
If it makes that much difference to you, you might want to try Quattro
Pro, which I believe lets you set the size of the worksheet. I know it
lets you expand to 1,000,000 rows, but I think you can also contract the
size of the sheet, too.

You, too, can pretend that Excel is dynamically sized by just ignoring
all those unused rows and columns. Print Preview will show only the
active area of the sheet.

Bill
 
Top