how do i stop rows from being ongoing
 

I'm trying to keep rows up to a certain point, but everytime I delete rows it
just adds them back in and continues to infiniti. How do I prevent it from
ongoing?

how do i stop rows from being ongoing
 

You actually can't delete rows - XL will just add them in again as you have
found. What you can do is hid the unwanted rows.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"julian" wrote in message
...
I'm trying to keep rows up to a certain point, but everytime I delete rows
it
just adds them back in and continues to infiniti. How do I prevent it
from
ongoing?

how do i stop rows from being ongoing
 

Julian
What do you want to happen to the rows that lie beyond the certain
point?
Do you want to hide them? As you have seen, deleting them simply replaces
them with new blank rows. HTH Otto
"julian" wrote in message
...
I'm trying to keep rows up to a certain point, but everytime I delete rows
it
just adds them back in and continues to infiniti. How do I prevent it
from
ongoing?

how do i stop rows from being ongoing
 

julian wrote:
I'm trying to keep rows up to a certain point, but everytime I delete rows it
just adds them back in and continues to infiniti. How do I prevent it from
ongoing?
Most of us ignore the unused rows and columns, If you insist, hiding
rows may be the best approach. If you really want to limit the size of
your worksheets switch to Quattro Pro. There you can create a 1 row by 1
column spreadsheet -- not too useful, but it is small...

And the rows don't continue until infinity. They stop at approximately
64k or 1 million, depending on the version of Excel.

Bill