![]() |
Is there a key combo to toggle between worksheets?
It seems that I have seen this before, but I may be mistaken. I am having to
toggle back and forth between 19 worksheets in a single workbook and it is a pain to have to click and scroll to each worksheet.... Any suggestions? |
Is there a key combo to toggle between worksheets?
You can use ctrl-pgup and ctrl-pgdn to cycle through the worksheets.
You can right click on the VCR/DVD like controls (to the left of the worksheet tabs) and choose a worksheet from that list. or you may want to try this from Debra Dalgleish's site: http://contextures.com/xlToolbar01.html LeaWarner wrote: It seems that I have seen this before, but I may be mistaken. I am having to toggle back and forth between 19 worksheets in a single workbook and it is a pain to have to click and scroll to each worksheet.... Any suggestions? -- Dave Peterson |
Is there a key combo to toggle between worksheets?
CTRL+ PgUp or PgDn
LeaWarner wrote: It seems that I have seen this before, but I may be mistaken. I am having to toggle back and forth between 19 worksheets in a single workbook and it is a pain to have to click and scroll to each worksheet.... Any suggestions? |
All times are GMT +1. The time now is 07:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com