crtl + page down or up does not cycle through sheets in excel 2007

  • Thread starter Thread starter John G.
  • Start date Start date
J

John G.

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
 
Office Button - Excel Options - Advanced - Scroll to the bottom, make sure
Transition navigation keys under Lotus compatibility is not checked.
Hope that helps...
 
Thanks, and no, it is not checked. Does having sheet protection enabled and
locked cells affect navigation?
 
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...
 
Thank you Boni,

That worked. I should quit trying to be fancy, stick with the basics. Thanks
again.

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 - fill down error 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Can I assign keyboard shortcuts for special characters in Excel 20 1
Adding a 2nd row of sheet tabs to Excel 2003 5
Selecting rows using CRTL, Shift and down or up arrows not working 4
Pivot Table Cycling Through Page Fields Automatically 14
ctlr+page up and ctlr+page down in 2007 5
Looping through data on consecutive pages 2

Back
Top