Unhiding a sheet

[Skint4sure]

I all

I have got a quiz on an excel spreadsheet but dont know all the answers but
figuren they are on sheet 2 of the workbook BUT that sheet is hidden.
How can I unhide sheet 2 OR find the answers?

thanks

 

[Gord Dibben]

Try Help "unhide" and look for unhide sheet.

You may be lucky and find the sheet is not "veryhidden", but just "hidden".

Gord Dibben Excel MVP

 

[Don Guillett]

Ask the teacher.

 

[KL]

The following may work:

In cell [A1] write:

=Sheet2!A1

and copy formula to a range of cells, say A1100.

Another way is to use the following macro:

Sub test3()
Sheet2.Cells.Copy Sheet1.Cells
End Sub

Regards,
KL