Organizing excel worksheet tabs

J

Jackson Lee

My user has at least 20 different worksheet tabs, he told me that he's seen
an ex-coworker organize the worksheets so that sheet 1-5 are in one column
in the work book and the others tabs are in another column.

Is it possible to do this? Because I do not see anyway in organizing the
worksheets

TIA,

Jackson
 
G

Gord Dibben

Your user may have seen someone with a VBA userform or somesuch which displayed
the sheets when enabled.

Not possible otherwise.

You can right-click on one of the navigation arrows at bottom left and get a 15
sheet list with "more sheets".


Gord Dibben MS Excel MVP
 
M

Mike Middleton

Jackson -

Maybe ...

Choose Window | New Window, and then choose Window | Arrange | Vertical.

Even then, each side-by-side window (perhaps what you are calling a
"column") shows a single sheet (and the other sheet tabs are seen at the
bottom of each window).

- Mike
http://www.mikemiddleton.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
making cells uncopyable 1
Copy certain rows to new worksheet 1
Time Difference - Post reconciliation Check 4
Macro for Sheet Navigation (Excel 2007) 1
Colors are suddenly shot, and Excel thinks there's two workbooks inmemory. 3
rows to columns conversion (or 90 degrees data turn) 8
Macro to format multiple worksheets 24

Top