How do I set the order for advancing cells using the Tab key?
J JR Hester Nov 13, 2007 #2 Versions prior to Excel 2007: Tools>Options>Edit tab> advance cursor on ENTER-- make selection here Version 2007: Office button(top left corner)>Excel Options button>Advanced --advance cursor on ENTER-- make selection here
Versions prior to Excel 2007: Tools>Options>Edit tab> advance cursor on ENTER-- make selection here Version 2007: Office button(top left corner)>Excel Options button>Advanced --advance cursor on ENTER-- make selection here
N Nick Hodge Nov 13, 2007 #3 Darin If you unlock some cells and protect the sheet, the tab key will toggle only the unlocked cells. Other than that there is no setting to change the tab key direction, just the enter key under Tools>Options...>General -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html
Darin If you unlock some cells and protect the sheet, the tab key will toggle only the unlocked cells. Other than that there is no setting to change the tab key direction, just the enter key under Tools>Options...>General -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected] web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html
G Gord Dibben Nov 13, 2007 #4 Depends upon the order. See Bob Phillips' site for more info and a couple of methods. Gord Dibben MS Excel MVP
Depends upon the order. See Bob Phillips' site for more info and a couple of methods. Gord Dibben MS Excel MVP