Excel 2003 - HOME key reprogrammed?

  • Thread starter Thread starter Tom Hall
  • Start date Start date
T

Tom Hall

All of a sudden, the HOME key in Excel has stopped moving the cell pointer
to the beginning of the row. Instead, it's sending the cell pointer to the
END of the row (actually, the cell immediately to the right of the last
cell in the row that contains data).

This behavior changed suddenly in the middle of my editing a worksheet:
copying data from one sheet and pasting it into another. I have no idea
what I could have done to change the HOME key's function. I tried going
back to worksheets that I'd saved some time ago, and the behavior was the
same. System restart did not restore the HOME key function either.

Stymied,


Tom
 
All of a sudden, the HOME key in Excel has stopped moving the cell pointer
to the beginning of the row.
Click to expand...

Disregard this. For some equally strange reason, the HOME key has returned
to its original function.

I did note however that pressing END just before pressing HOME reproduces
the behavior I was seeing that led me to post my original query, so I guess
it was the END key that was changing the behavior of the HOME key.


Tom
 
Disregard this. For some equally strange reason, the HOME key has returned
to its original function.
Click to expand...

Color me insane - un-disregard my original question.

I have one worksheet where pressing HOME *does* take the cell pointer to
the end of the row instead of the beginning, regardless of whether the HOME
key is preceded by the END key or not.

In this one spreadsheet, the only way I can get the cell pointer to the
first column is either single-stepping using the LEFT arrow key, or
repeatedly pressing CTRL-LEFT.

CTRL-HOME moves the pointer to the END of the FIRST row of the spreadsheet.

Tom
 
Sounds like you have changed the sheet orientation under
Tools>Options>International.

Are your row numbers on the right and column letters reversed?


Gord Dibben MS Excel MVP
 
Tom Hall said:
I have one worksheet where pressing HOME *does* take the cell
pointer to the end of the row instead of the beginning, regardless
of whether the HOME key is preceded by the END key or not.

In this one spreadsheet, the only way I can get the cell pointer to
the first column is either single-stepping using the LEFT arrow key,
or repeatedly pressing CTRL-LEFT.

CTRL-HOME moves the pointer to the END of the FIRST row of the
spreadsheet.
Click to expand...

Macros running OnKey are all I can think of that would cause this.
Does this particular workbook contain macros? Are you opening it with
macros enabled? If so, open it with macros disabled (change your macro
security setting to medium or high before opening the workbook). Does
the problem persist?
 
Sometimes best to take a deep breath, get a cup of java, relax and come back
to the problem. :)

Tyro
 
Sounds like you have changed the sheet orientation under
Tools>Options>International.

Are your row numbers on the right and column letters reversed?
Click to expand...

No, they aren't.

To answer the other respondent's questions, there are no macros in this
worksheet and setting the macro security level to high and to medium did
not solve the problem.

Even more interestingly, I then did a Ctrl-A Ctrl-C, got the usual warning
from Excel that the picture was too large and would be truncated. I pasted
this selection into a blank spreadsheet, did some formatting of column
widths and saved the sheet. The problem does not appear in this new sheet,
even after closing Excel and opening the worksheet several times.

The Excel sheet is a simple no-frills spreadsheet of receivables for my
little home business. All it contains are invoice numbers, payees, date
invoiced, amount, date paid and amount, with some conditional formatting
which shows the outstanding unpaid invoices in bold red. At the top far
right is a cell which keeps a running total of all unpaid invoices with a
window split to keep the first row on the screen while the rest of the
sheet scrolls.

Color me confused,


Tom
 
Back
Top