ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   I need a list of my tabs! (https://www.excelbanter.com/new-users-excel/158736-i-need-list-my-tabs.html)

DocumentControlPrincess

I need a list of my tabs!
 
I have a project in Excel that has about 300 tabs. Is there a way that I can
get a list of the tabs only?
--
~Christina

Peo Sjoblom

I need a list of my tabs!
 
If you right click the on the arrows to the left of the tabs you will get a
list
If you need a list in your cells you need to run a macro


http://www.mvps.org/dmcritchie/excel/buildtoc.htm

there is a UDF that will list all sheets on that page

--


Regards,


Peo Sjoblom





"DocumentControlPrincess"
wrote in message
...
I have a project in Excel that has about 300 tabs. Is there a way that I
can
get a list of the tabs only?
--
~Christina




DocumentControlPrincess

I need a list of my tabs!
 
Cool thanks!
--
~Christina


"Peo Sjoblom" wrote:

If you right click the on the arrows to the left of the tabs you will get a
list
If you need a list in your cells you need to run a macro


http://www.mvps.org/dmcritchie/excel/buildtoc.htm

there is a UDF that will list all sheets on that page

--


Regards,


Peo Sjoblom





"DocumentControlPrincess"
wrote in message
...
I have a project in Excel that has about 300 tabs. Is there a way that I
can
get a list of the tabs only?
--
~Christina






All times are GMT +1. The time now is 04:03 PM.

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