HOW TO FORMAT THE HOME KEY WITHOUT USING CTRL

S

Shelley

In the previous version of Excel that I was using when you used the home key
it brought you to the beginning of the worksheet.
In 2007 you have to use the Ctrl Home to go to the beginning. Is there a
shortcut to go directly to the beginning of the worksheet without using Ctrl?
Thank-you
 
J

Jacob Skaria

Home key takes you to ColA of the current row. Ctrl+Home takes you to cell
A1. It is same for both 2003 & 2007...Which version are you referrring to..
 
L

Luke M

What version of XL were you using?

At least in 2003, Home takes you to first cell in the row. (just like it
works in most text editing software) Ctrl+Home take you the beginning of
spreadsheet.
 
G

Gord Dibben

In previous version Home key would take you to column A, same row, as others
have pointed out.

BUT.........if you had Tools>Options>Transition Navigation Keys enabled Home
would take you to A1


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ctrl+home - Excel 2003 6
Ctrl and Tab functions broken 2
How do I make the home key return to the beginning of the row? 1
Ctrl+Home failure when sheet protected 1
Shortcut key to move to beginning of a worksheet 1
Ctrl+home not working, it takes me to the beginning of the row 1
Ctrl/Home changes the Zoom 4
How to make Ctrl-C, ctrl-V work in Office 2007 1

Top