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