
Signature
remove .spoo to reply by email
>>All of a sudden, the HOME key in Excel has stopped moving the cell pointer
>>to the beginning of the row.
>
>Disregard this. For some equally strange reason, the HOME key has returned
>to its original function.
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

Signature
remove .spoo to reply by email
Gord Dibben - 08 Jan 2008 21:42 GMT
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
>>>All of a sudden, the HOME key in Excel has stopped moving the cell pointer
>>>to the beginning of the row.
[quoted text clipped - 15 lines]
>
>Tom
Tom Hall - 09 Jan 2008 00:05 GMT
>Sounds like you have changed the sheet orientation under
>Tools>Options>International.
>
>Are your row numbers on the right and column letters reversed?
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

Signature
remove .spoo to reply by email
Gord Dibben - 09 Jan 2008 00:19 GMT
I am same color<g>
Gord
>Color me confused,
Harlan Grove - 08 Jan 2008 21:44 GMT
Tom Hall <aria1...@gmail.com.spoo> wrote...
...
>I have one worksheet where pressing HOME *does* take the cell
>pointer to the end of the row instead of the beginning, regardless
[quoted text clipped - 6 lines]
>CTRL-HOME moves the pointer to the END of the FIRST row of the
>spreadsheet.
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?