Can I have my open files in Excel be viewed in tab form?

Question

When I have 5 or so different open files in Excel 2000, can I view them in tab form, or something easier than having them minimize behind the current screen. I know I can arrange them vertically, etc. but that doesn't work too well with too many files. I can also click the Window tab and find my files there.... but I am looking for something more efficient. Any ideas?

Answer 1

Right click on the tab, click shift to select more if necessary, click move to, select the name of the workbook to hold the other workbooks. Now all your workbooks are consolidated into one and view using tabs