How can I set a "page end" point on a large worksheet?

  • Thread starter Thread starter kpetefaith
  • Start date Start date
K

kpetefaith

I am a fairly new user to Excel. I have created a worksheet with over 200
lines of data. When I use the "control end" shortcut, I end up way down at
the end, if you know what I mean.
Is there a way to set the end of my page at the actual end of my data?

Thanks.
 
Dave,
Have you tested this? I did this and it didn't remove the extra rows.
Could be user error but I wanted to check anyway.
 
Yep.

Did you remember to save the workbook. There's a note on that page that some
versions require saving (and closing/reopening???).
 
Back
Top