Unhiding a sheet

S

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
 
G

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
 
K

KL

The following may work:

In cell [A1] write:

=Sheet2!A1

and copy formula to a range of cells, say A1:p100.

Another way is to use the following macro:

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

Regards,
KL
 
Top