+ Reply to Thread
Results 1 to 5 of 5

Left-handed keyboard shortcut to toggle through worksheets

  1. #1
    Registered User
    Join Date
    11-27-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Question Left-handed keyboard shortcut to toggle through worksheets

    Have tried searching for an answer to no avail...

    I am looking to create my own custom keyboard shortcut to toggle between worksheets within my workbook.
    I prefer to solve this without the use of macros, as I am on an office server that triggers security warnings when macros are in use (plus I want this to be available to me in every workbook I use).

    I have found plenty of suggestions for the Ctrl + Page Up or Page Down solution.... what I want is a left-hand only keystroke (similar to using the 'Alt + Tab' in Windows to toggle between open programs on my computer).

    Ideally I would use 'Alt + 1' to move to the previous worksheet, and 'Alt + 2' to move to the next.

    My search for an answer has lead me to believe that customi keyboard shortcuts in excel are not possible(?)

    The closest I have gotten to a solution would be to customise my Quick Access Toolbar, and use 'Alt + *digit*' as a keyboard shortcut to that command... HOWEVER - I am unable to find the required command in the dropdown list of 'All Commands' to achieve the function I'm looking for 'Go To Next worksheet' and 'Go To Prior Worksheet'. Can anyone enlighten me as to what category it's in or what title this command is called?

    In short, I'm looking for a left-hand only keyboard shortcut to quickly toggle between my worksheets. The Ctrl + Page Up/Down is a right handed shortcut.

    TIA

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Left-handed keyboard shortcut to toggle through worksheets

    Hello,

    if you want this to be available in all workbooks, you will need code. Excel does not have any global settings for what you describe.

    Don't shoot the messenger.

  3. #3
    Registered User
    Join Date
    11-27-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Left-handed keyboard shortcut to toggle through worksheets

    Thanks for the quick reply teylyn

    Are you saying that there is definitely no quasi 'Go to next sheet' command somewhere under this dropdown list?

    Capture.JPG

    Cheers!

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Left-handed keyboard shortcut to toggle through worksheets

    Yes. As far as I'm aware there is no command to click on the ribbon to go to the next or previous sheet. Since the sheet tabs are typically visible, they can be clicked directly instead of clicking a ribbon icon. The Ctrl-pgUp etc. provides a keyboard shortcut, but it can only be done single-handedly with the right hand.

    You could write VBA and store it in your Personal.xlsb, then assign a keyboard shortcut to that VBA.

    Can you run a personal.xlsb in your setup? It will load when you start Excel.

  5. #5
    Registered User
    Join Date
    11-27-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Left-handed keyboard shortcut to toggle through worksheets

    Thanks for the info - that all makes sense. I'll do as you've suggested. Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 03-06-2017, 09:39 AM
  2. keyboard shortcut for right-click menu for worksheets
    By pingpong777 in forum Excel General
    Replies: 1
    Last Post: 10-25-2012, 08:25 PM
  3. Keyboard shortcut for single left click in Excel cell
    By johnnylzep in forum Excel General
    Replies: 1
    Last Post: 09-04-2012, 04:07 AM
  4. Keyboard shortcut for switching through worksheets
    By sinke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2010, 03:47 AM
  5. [SOLVED] keyboard shortcut between worksheets?
    By Chris Hedlund in forum Excel General
    Replies: 9
    Last Post: 01-31-2006, 07:45 PM
  6. Replies: 0
    Last Post: 09-13-2005, 06:05 PM
  7. Keyboard Shortcut for moving between Worksheets
    By mjcoco in forum Excel General
    Replies: 3
    Last Post: 06-03-2005, 11:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1