Next Live Training Date:

13- 17 May, 2013

Multiple Excel Windows

Multiple Excel Windows
Watch this video

How to work with multiple excel windows at the same time including looking at 2 different spreadsheets or 2 sheets from the same workbook

  • 4:01
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Multiple Excel Windows

In this example you have a fairly large spreadsheet, and what you’d like to do is be able to look at the top and the bottom of the spreadsheet at the same time i.e. multiple excel windows at the same time. You can do this by splitting the screen, and there are two ways to do this

And you’ll be given more sections. And what this allows you to do is view one section of spreadsheet while scrolling down to get to another section of the spreadsheet.

There is another way to do this as well,

and set up your screens like that.

If you don’t like the split screen where both sections can be moved, it’s always possible to freeze a frame, so for example

Sometimes a situation may arise where you want to look at two different spreadsheets at the same time, for this you can use the Window Arrange feature. So for example you’ll see I’ve got two spreadsheets open,

And you can now work through the one and quickly compare it to the other. Just to show you how the others look

The last situation is where you actually want to view two different sheets in the same spreadsheet at the same time. So

Now how do you view both sheets at the same time, again

The two same spreadsheets are there, except you can now on the one of them click on the other sheet, and it’s possible now to view both spreadsheets at the same time. And any changes you make to either one will be reflected in the one copy, and when you save it will be saved as one copy only.

Handy Tips & Tricks

Showing zeros in Excel

Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically … Continue reading

Separating Lines within a cell

If IĀ understandĀ the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading

We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.

– KRONES Lifecycle Service Center Africa

Video Library & Tutorials //

View Entire Video Gallery ››

Spreadsheet tests

Spreadsheet tests

Spreadsheet Change Control

Spreadsheet Change Control

Waterfall chart using stock charts

Waterfall chart using stock charts

Absolute and Relative cell references

Absolute and Relative cell references

Some of our Featured Clients