Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you copy from Excel (see 1 below) and paste into Word (2) WITHOUT seeing the filter button, gridlines, comment notes and more?

Guess and then view answer to see how it can be done!


How to work on two different excel worksheets at once

How to work on two different excel worksheets at once

A common requirement is how to work on two different excel worksheets at once. The wording is important. It is not two different SPREADSHEETS, but rather two (or more) worksheets within the same spreadsheet.

To do this you need to use the VIEW tab in Excel. Click on the NEW WINDOW button. You will notice that it appears as if Excel opens a new spreadsheet. Look carefully at the name of the spreadsheets and you will notice that one of them is :1 and the other is :2. This is telling you that it is view 1 and 2 of the same spreadsheet.

To get the most effective use, now you can click on the ARRANGE ALL button and choose how you want to see the spreadsheets. When they are side by side you can work on either one. Any changes you make are shown on both (even though there look like there are 2, in Excel’s mind there is only one).

To see how to do this you can watch the Multiple Windows video clip

For more attend our Excel training sessions


Spell check Excel documents