How to get all of the tabs at the bottom of the worksheet?

[Wilgoss]

HI - I've searched for an hour to find this on the internet but resort to hear now because you guys know everything!

I know that I can click on one value and have a new "Sheet1" showing at the bottom of my worksheet but how do I simply display all the sheets with one per respective field

I've done it before once but cant remember how!

Thanks in advance

[Debraj Roy]

Do you want to view all sheet's in a single window... something like side by side.. !!

[Wilgoss]

Do you want to view all sheet's in a single window... something like side by side.. !!

That's it - I could click on each result to bring up sheets one by one but I've over 100 sheets and I know it can be done - just can't recall how!

[Wilgoss]

Do you want to view all sheet's in a single window... something like side by side.. !!

Any idea howthen?

[FDibbins]

Im not sure I understand what you want?

Do you want to see the contents of 1 particular cell (say A1) from all (100) worksheets? Or do you want to see all (100) worksheets, all showing A1, on the same wndow?

[Wilgoss]

Maybe I wasn't clear. Basically I know that when I doube click on a result in a pivot table it will Show Details and create a new tab called Sheet1 and the next result I click on will create Sheet2 etc etc. Recently I, by accident, managed to click on something somehow which said or showed something like "Show all details" and when I clicked it, every sheet opened up at the bottom of the spreadsheet side by side numbered Sheet1 through to Sheet45. This is what I want to achieve - and if there's a way of doing it so that it labels then with the source name i.e. where I've double clicked on the number "2" next to "KLP" and it names the sheet KLP instead of sheet1 - that would save me hours!

Thanks in advance

[Wilgoss]

Any help at all please?