ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   tab to next unlocked cell (https://www.excelbanter.com/excel-discussion-misc-queries/259316-tab-next-unlocked-cell.html)

ajimmitt

tab to next unlocked cell
 
Hi... hope you can help.
I have a spreadsheet with locked and unlocked cells. I would like to TAB to
the next unlocked cell available. Is there an easy way to set this up?
Thank you.

Russell Dawson[_2_]

tab to next unlocked cell
 
Excel actually does this for you. Once you have established you unlocked
cells and protected the w/sheet you get the result you are looking for. If
it's not doing it you have probably not protected the w/s.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ajimmitt" wrote:

Hi... hope you can help.
I have a spreadsheet with locked and unlocked cells. I would like to TAB to
the next unlocked cell available. Is there an easy way to set this up?
Thank you.



All times are GMT +1. The time now is 12:34 AM.

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