excel 2000 extending seemingly infinitely

[excel 2000 hopeless]

Hello. When I opened excel 2000, the spreadsheet pages continued weemingly
without limit, both vertically and horizontally. Therefore couldn't get to
the bottom of the page to click over to other pages. Any idea how to correct?

 

[Kassie]

You do not say what your level of expertise is?
Your spreadsheet contains 65536 rows, and something like 256 columns, not
devided into pages. The only time that you will see pages in an Excel
spreadsheet, is when you work in Page Break Preview, from the View menu. A
workbook normally contains 3 worksheets to start off with, and you can of
course insert more sheets as and when required.
The tabs to the other worksheets are located at the bottom left of yor
window, marked Sheet1, Sheet2 etc.
Maybe, if you elaborate on your problem, we can better assist you.

--
HTH

Kassie

Replace xxx with hotmail

 

[excel 2000 hopeless]

Dear Kassie: Thanks very much, in particular because I have no expertise of
any kind and am really lost on how to deal with this. I'll try to decribe
the situation again.

For orders from one of our distributors, the distributor provided us with an
excel 2000 template. In the past, we entered data in two pages/spreadsheets
of cells; we could go from one page/spreadsheet to the other to via two tabs
at the bottom of each page/spreadsheet, labeled 'header' and 'detail.'

Yesterday, when I opened the excel program, I was, as per usual, in one
page/spreadsheet (I believe 'detail'). But when I scrolled down to find the
tabs (to go to 'header'), I could never reach the bottom of the page. Thus,
I could only enter data on the 'detail' page.

Another change: before, when I opened excel, the spreadsheet filled my
computer screen. Now it's offset towards the lower right, with perhaps 1.5
inches of unused gray at the left of the screen, and .4 inches of gray at top.

These changes (bottomless spreadsheet, margins at left and top) now affect
every excel that I've opened up from our archives (to check what's going on).
However, when we send spreadsheets to other people (I've sent them to
friends and to the distributor, for help), the spreadsheets work fine. So it
would seem to be something has changed within our computer.

It's vexing as all get out, and I thank you for your kind support.

 

[Kassie]

OK, I think what happened is that you moved your Excel window down and right.
Scrolling down will NOT get you to the tabs. Instead, do one of two things.
move your cursor to the blue portion of the excel sheet, where it displays
the name of the workbook, then click, hold the mouse button depressed, and
move your cursor to the left and top, until the sheet fills the screen again.
Once you have it back in position, you should see the two tabs at the bottom
again. Also, you should see three buttons on the top right of the sheet. If
there are three similar buttons directly below these three buttons - an
underscore, an icon of two offset sheets, and an X, then click on the middle
button of the lower set. That should also correct the position of your
sheet, so that you can again see the two tabs at the bottom.

--
HTH

Kassie

Replace xxx with hotmail