Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
crtl + page down or up does not cycle through sheets in excel 2007
I used to be able to cycle through worksheets with the crtl pg up or down
combo but I am now using 2007 on an xp machine with sp3. Am I missing a simple setting? Driving me nuts! :-) John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
crtl + page down or up does not cycle through sheets in excel 2007
Office Button - Excel Options - Advanced - Scroll to the bottom, make sure
Transition navigation keys under Lotus compatibility is not checked. Hope that helps... "John G." wrote: I used to be able to cycle through worksheets with the crtl pg up or down combo but I am now using 2007 on an xp machine with sp3. Am I missing a simple setting? Driving me nuts! :-) John |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
crtl + page down or up does not cycle through sheets in excel
Thanks, and no, it is not checked. Does having sheet protection enabled and
locked cells affect navigation? "BoniM" wrote: Office Button - Excel Options - Advanced - Scroll to the bottom, make sure Transition navigation keys under Lotus compatibility is not checked. Hope that helps... "John G." wrote: I used to be able to cycle through worksheets with the crtl pg up or down combo but I am now using 2007 on an xp machine with sp3. Am I missing a simple setting? Driving me nuts! :-) John |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
crtl + page down or up does not cycle through sheets in excel
If you have disabled Select locked cells and enabled Select unlocked cells,
yes it will. If both are either off or on, it works great... "John G." wrote: Thanks, and no, it is not checked. Does having sheet protection enabled and locked cells affect navigation? "BoniM" wrote: Office Button - Excel Options - Advanced - Scroll to the bottom, make sure Transition navigation keys under Lotus compatibility is not checked. Hope that helps... "John G." wrote: I used to be able to cycle through worksheets with the crtl pg up or down combo but I am now using 2007 on an xp machine with sp3. Am I missing a simple setting? Driving me nuts! :-) John |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
crtl + page down or up does not cycle through sheets in excel
Thank you Boni,
That worked. I should quit trying to be fancy, stick with the basics. Thanks again. John "BoniM" wrote: If you have disabled Select locked cells and enabled Select unlocked cells, yes it will. If both are either off or on, it works great... "John G." wrote: Thanks, and no, it is not checked. Does having sheet protection enabled and locked cells affect navigation? "BoniM" wrote: Office Button - Excel Options - Advanced - Scroll to the bottom, make sure Transition navigation keys under Lotus compatibility is not checked. Hope that helps... "John G." wrote: I used to be able to cycle through worksheets with the crtl pg up or down combo but I am now using 2007 on an xp machine with sp3. Am I missing a simple setting? Driving me nuts! :-) John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
cycle count with Excel | Excel Discussion (Misc queries) | |||
excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
Crtl+V Problem in Excel | Excel Discussion (Misc queries) |