ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a key combo to toggle between worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/175924-there-key-combo-toggle-between-worksheets.html)

LeaWarner

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?

Dave Peterson

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

Bob I

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