viewing spreadsheets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Viewing spreadsheets

Viewing spreadsheets

resolvedResolved · Low Priority · Version 2003

Anasta has attended:
Excel Intermediate course

Viewing spreadsheets

How can i view various different workbooks in one window?

RE: Viewing spreadsheets

Dear Anasta

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

To view more than one workbook on the same screen please follow these steps:

1. In Excel open all the files that you wish to view on the same screen.

2. Choose Window > Arrange... from the menu bar.

3. Choose how you would like the workbooks to be viewed i.e. Tiled, Horizontal, Vertical or Cascade.

4. Press OK.

Note that if you are comparing only two workbooks then you can simply choose Window> compare side by side with... option. If you have lots of workbooks open the dialog box will ask you which workbook you want to compare the current workbook with.

Once you have arranged the workbooks on the screen you can save the layout as a workspace so that you don

Fri 16 Jan 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Stop Formula Returning A "#DIV/0" Error

If a formula returns a #DIV/0 error message there is a way to avoid such results.

For example the formula =A1/B1 will return a #DIV/0 if B1 is empty or a zero.

If you protect your formulas with the ISERROR function, the formula will then look like this:

=IF(ISERROR(A1/B1),0,A1/B1)

In plain English: should the result of A1 divided by B1 be an error change the result to 0 else show the result of A1/B1.

View all Excel hints and tips


Server loaded in 0.08 secs.