Evie

You could hide the empty rows and columns if you wish.

You can, through code, set the scrollarea so users cannot scroll out of the
range you set.

Another thing......Excel has a habit of over-estimating the used range.

When you hit CTRL + End where does that take you?

If far below and right of your actual used range, you can select the rows below
and delete them.

Also select the columns to the right of your used range and delete them.

Save the workbook and your CTRL + End will go to last cell of your real used
range.


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 08:26:01 -0800, Evie wrote:

I will try those things. I still want to know how to restore the end of the
worksheet (worksheet tabs, scroll bar). I've had this happen to me once and
I didn't resolve it. Currently, if you go to the bottom of the spreadsheet
you just continue down the endless empty rows.

Evie


"HALinNY" wrote:



"Evie" wrote:

I sent a worksheet out to a group and some people receive it just as it is
formatted and others don't see the first column without pulling it over and
also the bottom (tabs and scroll bar) aren't visible.

The document is protected. I had one person save a copy and the first
column came into view, but still the workbook tabs and bottom scroll aren't
visible.


That's normal because Excel remembers the size and position of your window
arrangement and then uses it on the other persons computer. If there is a
difference in the display properties between your computer and the other
person's computer they will see things differently than you do.

One of the things you can do to minimize this is to make your Excel window
about one-quarter the size of your screen, or even a little smaller, before
you save it and send it to others.

Another thing you can do (I am pretty sure) is to maximize the windows
before you save it. Maximize is a device-independent "size" and is usually
handled differently than a non-maximized window.

B+
HALinNY
I checked such things as the view tabs and scroll bar and they are checked.