MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cells with X shift to right 1 cell


Posted by Jim on July 31, 2001 9:59 AM

Hi i have a worksheet with 2 colums of x "Col D&F"
after i make an entry in say C17 could it skip the
next cell with the X and be active in E17?
Any ideas would be appreciated.
Jim


Posted by lenze on July 31, 2001 12:43 PM

If you unlock the cells where you want to enter data in Format>Cells>Protection and then protect the worksheet, you can use the TAB key to navigate between the unlocked cells, skipping the locked ones.