• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shortcut keys for moving in multi tab within same excel sheet

S

shankar_iyer83

Member
Hi,


I was working with a file with 20 tabs in a single file..


Now the thing is..if we 2 excel sheets..we do ALT+TAB to go to last working sheet


But is there any shortcut for multi tabs..


like suppose If I am working on 2 tab...and then i move to 18th tab...then again if i have to go to 2 tab????( I KNOW..WE HAVE CTRL+PAGEUP/DOWN) KEYS.. to move to different tabs..just wanted to know if we have shortcut kry for this..


thanks
 
Right clicks on the <> arrows bottom right of screen


or


Ctrl G, Type Sheet18!A1
 
hI HUI,


can u elaborate on ur second shorcut?


Like if i have one excel sheet with three tabs named-x1,x2,x3


I am on tab x3..


now if i want to move to x1..i type sheetx1!A1..this shows error....
 
You must log in or register to reply here.
Back
Top