Clearing unseen data

  • Thread starter Thread starter Ralphael1
  • Start date Start date
R

Ralphael1

I have a Excel page with data that ends at linbe 602 however when I
click alt end it jumps down to 2750.
I have tried deleting all the rown 603 to 2750 and clearing the
contents but it does not work. Anyone have a to solve this.
Thanks,
Ralphael, the OLD one
 
After deleting the rows, save the file. That will set the new last cell.
 
And make sure you delete the rows, not just "Clear Contents".


Gord Dibben Excel MVP
 
Gord said:
And make sure you delete the rows, not just "Clear Contents".


Gord Dibben Excel MVP

Thank you Gord, you have relieved a portion of my computer pain.

Ralphael, the OLD one
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight cell 1 and move to last cell 4
Task bar problem 2
Arrow font 4
Pointer problem 4
Wrap not wrapping 6
Display value if next cell below is zero 2
more trouble with i 9
How Do I Avoid #REF! In Formulas? 4

Back
Top