ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Tab and Enter key to move in spreadsheet? (https://www.excelbanter.com/setting-up-configuration-excel/23945-tab-enter-key-move-spreadsheet.html)

Wayne Lee

Tab and Enter key to move in spreadsheet?
 
I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

Kassie

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?


Wayne Lee

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?


Lady Layla

Also, you could reprotect the sheet and select the option to only allow the user
to select unlocked cells


"Wayne Lee" <Wayne wrote in message
...
: I just came out of a Mac and when I protected a spreadsheet I could hit Enter
: to move to the next unprotected cell. In the PC version, enter moves down a
: cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
: to change the function of the enter key?



Gord Dibben

Wayne

You will have to stick with the Tab key to move to unlocked cells.

Kassie's ENTER key suggestion will not work.

No matter which direction you set the ENTER key to move, it will not go to
next unlocked cell as the Tab key will.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 06:42:08 -0700, Wayne Lee
wrote:

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?



Gord Dibben

OOPS!

Sorry Kassie and Wayne.

If running xl 2002 or 2003 you can, when protecting the sheet, allow selection
of unlocked cells only.

Then the ENTER key set to go right will work.

Earlier versions did not have this feature.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 15:57:53 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Wayne

You will have to stick with the Tab key to move to unlocked cells.

Kassie's ENTER key suggestion will not work.

No matter which direction you set the ENTER key to move, it will not go to
next unlocked cell as the Tab key will.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 06:42:08 -0700, Wayne Lee
wrote:

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?




All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com