MrExcel Publishing
Your One Stop for Excel Tips & Solutions

can I move from cell to another (and skip some cells) by pressing the tab key or some other key?


Posted by kevin on January 15, 2002 6:44 AM

Would it be possible to make the cursor move from cell to another, for example from cell C3 to F3, with the pressing of the tab key? I have a spreadsheet and I would like it if the user could press the tab key and it would automatically take them to the cell they need to be in to enter data.

Thanks in advance,
Kevin


Posted by Barrie Davidson on January 15, 2002 6:47 AM

Kevin, you can achieve this by "unlocking" the cells you want to enter data in (Format|Cells and select the "Protection" tab) and then protecting the worksheet.

Regards,
BarrieBarrie Davidson

Posted by Kevin on January 15, 2002 7:52 AM

Thanks Barrie