Worksheets and Save

[gary]

Question 1:

In Excel 2000, I'm working with a workbook with many
worksheets.

How can I see the contents of Sheet1 and Sheet2 (or more)
at the same time? (Similar to Window/Arrange/Vertical).

=============================

Question 2:

When I save a workbook, the Status bar shows:

1. "Saving" plus the filename
then
2. MICROSOFT EXCEL 5.0/7.0 and "Saving" plus the filename.

Is the workbook being saved twice?

 

[Dave Peterson]

Do "Window|New Window" first. Then the arrange stuff will work nicely.

To close one of the windows, just click on it and hit ctrl-F4.

And you're saving in a combination format. It doesn't save the file in two
locations, but essentially saves the workbook twice within the same file--once
as 5.0 and once as 7.0.

This can be useful when you're sharing the workbook with someone who still runs
xl95.

But if you don't share this with anyone using xl95, do a File|SaveAs and choose
MS Excel Workbook (at the top of the "Save as Type:" box.