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

viewing spreadsheets

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

Viewing spreadsheets

ResolvedVersion 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.

Excel tip:

Autofit column width – Excel (all versions)

a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column.
b. Double click the dividing line between the columns. This dividing line is the break between the columns on the column headers (grey buttons showing the column letter at the top of each column). When you hover your mouse over one of these dividing lines the point will change and show an arrow pulling a line in two directions. When you have this mouse pointer you should double click to get Excel to automatically set the column width to fit the contents of the column (autofit)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.