ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Strange question on tabs (https://www.excelbanter.com/excel-worksheet-functions/214610-strange-question-tabs.html)

Dylan @ UAFC[_2_]

Strange question on tabs
 
When I protect my sheet I lose the tab key.
Any suggestion
Please advise
DL

Spiky

Strange question on tabs
 
On Dec 24, 10:13*am, Dylan @ UAFC
wrote:
When I protect my sheet I lose the tab key.
Any suggestion
Please advise
DL


Unlock some cells. Tab may appear to simply move to the right, but it
really moves to the next available cell. You have none available.

Dylan @ UAFC[_2_]

Strange question on tabs
 
Icant there are several very involed fomulas inthe cells.
I advise was just use the arrow keys but they hate that.
Moreoever there are 3 columns in a row that are unprotected
and still notabs

"Spiky" wrote:

On Dec 24, 10:13 am, Dylan @ UAFC
wrote:
When I protect my sheet I lose the tab key.
Any suggestion
Please advise
DL


Unlock some cells. Tab may appear to simply move to the right, but it
really moves to the next available cell. You have none available.


Spiky

Strange question on tabs
 
On Dec 24, 10:32*am, Dylan @ UAFC
wrote:
Icant there are several very involed fomulas inthe cells.
I advise was just use the arrow keys but they hate that.
Moreoever there are 3 columns in a row that are unprotected
and still notabs

"Spiky" wrote:
On Dec 24, 10:13 am, Dylan @ UAFC
wrote:
When I protect my sheet I lose the tab key.
Any suggestion
Please advise
DL


Unlock some cells. Tab may appear to simply move to the right, but it
really moves to the next available cell. You have none available.


Hmm. Seems like it should work. They are able to type in certain
cells? Are these simply unlocked cells or did you use "Allow Users to
Edit Ranges"? They need to be "Unlocked". The "Allow Users..." is a
different setting that doesn't allow Tab to work.


All times are GMT +1. The time now is 03:06 AM.

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