how do i stop rows from being ongoing

  • Thread starter Thread starter julian
  • Start date Start date
J

julian

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?
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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 said:
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?
Click to expand...
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
 
Back
Top