You can't make a worksheet transparent but you may be able to achieve your
objective with the Camera tool.

Select area in a sheet you want to see on another sheet and Copy

Move to the other sheet. Hold Shift and select Edit from the main menu,
Paste Picture Link. There's a limit to the size of area, so not the entire
sheet.

This is not the same as taking a picture of an area (Shift-Edit, Copy
Picture).

Regards,
Peter T

"spIky haIred" wrote in message
oups.com...
Hi all,

I am trying to make the worksheets in Excel
semi-transparent/transparent... so that if I am in Sheet1, I will be
able to see data in Sheet2. Is this possible at all? and if so can
someone lead me in the right direction...

Thanks.