viewing group of selected sheets?

[lakegoddess]

Is Excel able to filter out specific sheets for viewing? I have sheets A1, A2,... A10, B1, B2,... B10, ... and so on. Is there a way of just viewing all sheets whose names start with A? B? Etc.?

[swatsp0p]

I think you posted a similar question yesterday. What do you mean "View" specific sheets? Do you expect all 10 sheets to be on screen at the same time? Do you want to 'group' the sheets to make one edit affect all selected sheets? Do you want to Hide sheets from other's view or simply to get them out of the way?

You need to be more specific, please. What is your desired outcome?

[lakegoddess]

Thanks for your reply. I guess what I need is to view 10 sheets on the screen at a time. I have to do a presentation showing these specific sheets (let's say only sheets beginning with A) so if my boss asks me to show the reports for all the A's, I can click a button and it shows up only the A's (filtering out the others, but not deleting them), instead of scrolling through my worksheets and clicking on the ones I want. Is that clear? Let me know if you need more clarification.