How to work with multiple excel windows at the same time including looking at 2 different spreadsheets or 2 sheets from the same workbook
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.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd