ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tab Through worksheet (https://www.excelbanter.com/excel-worksheet-functions/105845-tab-through-worksheet.html)

Excel neophyte

Tab Through worksheet
 
Is there a way, such as in Word, when the sheet opens the curser immediately
goes only to the unlocked cells that need to be filled and you tab to the
next?

Thanks!

KePaHa

Tab Through worksheet
 
Those cells which should remain active for data entry, highlight them, Format
Cells, Protection, Unlock them. Then Tools, Protect, Protect Worksheet.

"Excel neophyte" wrote:

Is there a way, such as in Word, when the sheet opens the curser immediately
goes only to the unlocked cells that need to be filled and you tab to the
next?

Thanks!



All times are GMT +1. The time now is 03:31 PM.

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