FIND A WORKSHEET..
27 views
Skip to first unread message
Basavaraj Alagundgi
Aug 23, 2013, 1:55:09 PM8/23/13
to losti...@googlegroups.com
Pl let me know the keyboard shortcut to find particular worksheet out of 100 worksheet
in a workbook.before few months I was using it, now I have forgotten.
It is just like using Ctrl+F to find a name in a column. Now I have to search
with Ctrl+Page up/Page down which is tough to find Sheet75, in a workbook
of 200 sheets.
Pl help me
in a workbook.before few months I was using it, now I have forgotten.
It is just like using Ctrl+F to find a name in a column. Now I have to search
with Ctrl+Page up/Page down which is tough to find Sheet75, in a workbook
of 200 sheets.
Pl help me
Manoj Kumar
Oct 5, 2013, 6:44:29 AM10/5/13
to losti...@googlegroups.com
Hi Basavaraj,
you can use <Go to > window by pressing <F5> then you put the sheet name with cell number where you want to reach
like 'Sheet 200'!C11
Note :- Sheet name must be in single quotes.
Many Thanks
you can use <Go to > window by pressing <F5> then you put the sheet name with cell number where you want to reach
like 'Sheet 200'!C11
Note :- Sheet name must be in single quotes.
Many Thanks
Reply all
Reply to author
Forward
0 new messages