Hi ACJC4602,

If you mean that hitting Ctrl End takes you to a location outside your
anticipated data area, see Debra Dalgleish notes on resetting the UsedRamge
at:
http://www.contextures.com/xlfaqApp.html#Unused

To restrict user access to a desinated contiguous range try:

Sub Tester()

ActiveSheet.ScrollArea = "A1:G20" '<<===Change to suit

End Sub

If you are not not familiar with macros, you may wish to visit David
McRitchie's site and look at his 'Getting Started With Macros And User
Defined Functions' page:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

---
Regards,
Norman



"acjc7602" wrote in message
...
Sometimes when I am working in excel I unintentionally create extra rows
that
have nothing in them on the sides and at the bottom of my worksheet. I
think
I do this by scrolling over further than I need or scrolling down further
than I want the screen to go. But then I cannot go and delete those extra
rows at all. They are just out there without anything in them. Is there a
way
I can either delete those or only allow someone who uses my worksheet to
see
the rows and columns I want them to see when they open it up?