View two worksheets simultaneously.

Hi All
I use a two monitor setup driven from a Radeon 9550 graphics card, but the problem I have occurs on a single monitor as well.

When I open multiple workbooks or worksheets I can only view one at a time the other remains embedded behind the open window.

Nothing I know of will let me view both at the same time.

If there are two open worksheets full size on the screen and I minimize one they both minimize.

If I decide to close one workbook/sheet down all open workbooks/sheets close down as well.

My question/s

Can I view two workbooks at the same time? Can I close one down while keeping one open?

TIA thalt