Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Excel 2003 - HOME key reprogrammed?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tom Hall - 08 Jan 2008 20:00 GMT
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

Signature

remove .spoo to reply by email

Tom Hall - 08 Jan 2008 20:19 GMT
>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.

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

Signature

remove .spoo to reply by email

Tom Hall - 08 Jan 2008 21:27 GMT
>>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?
Tyro - 08 Jan 2008 21:53 GMT
Sometimes best to take a deep breath, get a cup of java, relax and come back
to the problem. :)

Tyro

> 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
[quoted text clipped - 10 lines]
>
> Tom
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.