ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how can find sheet on workbook have so many sheet ? (https://www.excelbanter.com/excel-worksheet-functions/167043-how-can-find-sheet-workbook-have-so-many-sheet.html)

Huy Nguyen

how can find sheet on workbook have so many sheet ?
 
My workbook have so many sheets. Now I want find 1 sheet, I must click to
button left or right of workbook for move to my sheet want do. How can find
it so fast.
Thanks & Best Regards.

Roger Govier[_3_]

how can find sheet on workbook have so many sheet ?
 
Hi

If you right click on the far right arrow of the sheet navigator, it will
display a list of all Sheet names.
Just select the one you want.

Alternatively, Dave Peterson has written some code to create a floating
sheet navigator.
It can be downloaded from
http://www.contextures.com/xlToolbar01.html

--
Regards
Roger Govier



"Huy Nguyen" <Huy wrote in message
...
My workbook have so many sheets. Now I want find 1 sheet, I must click to
button left or right of workbook for move to my sheet want do. How can
find
it so fast.
Thanks & Best Regards.





All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com