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. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

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!


Excel spreadsheet open but not visible

If you comes across a situation where an Excel spreadsheet is open but not visible, you may find that it has been hidden by a user in a way that they did not understand.

The normal way to hide a sheet it to right click on it and click the hide option or go via the HOME tab as shown below

Excel spreadsheet open but not visible

If you do it this way, the spreadsheet workbook remains visible but the sheet is hidden. To get it back you click on any of the other sheets and then click UNHIDE.

Spreadsheet open but not visible

However, sometimes when you open a workbook, you see that it is open but you can’t actually see it. This could be as a result of an intentional or accidental hiding of the workbook (as apposed to a sheet).

Under the VIEW tab you will see buttons called Hide and Unhide.

Excel spreadsheet open but not visible

It is easy to assume that this relates to the sheet you are on, but in fact it relates to the whole workbook. If you click HIDE, the workbook will disappear but it is still operational and open.

In order to see it again, click the UNHIDE option in the VIEW tab and it will give you a list of hidden workbooks. You can then choose the one you want to see and click OK, and it will re appear.

Select visible cells button

Summing, Counting, or Averaging visible cells only in Excel

SUMPRODUCT only visible cells