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