Excel 2002 SP3 ~ annoying problem

  wee eddie 17:43 22 May 2008
Locked

I am trying to View 2 Spread Sheets, side by side.

However whenever I open the two. I am only able to view the one at a time. The other automatically Minimises or goes to the back.

I run XP and have 1GB of RAM.

Any ideas would be welcome, short of printing the both of them.

  VoG II 17:48 22 May 2008

Try opening a new window click here

  wee eddie 18:47 22 May 2008

I just tried by opening the first, but can find any way of opening another Window as they they open on my Desktop not in IE, even with both Open, only one will display at a time.

They are not 2 Workbooks of the same Spreadsheet

  VoG II 18:58 22 May 2008

I can't remember whether XL 2003 has Window > Arrange All or Window > Compare side by side but they work with multiple workbooks.

  Woolwell 20:17 22 May 2008

Try this Tools - Options - View Tab - and under Show check Windows in Taskbar.

  wee eddie 20:21 22 May 2008

Unfortunately in XL 2002, it just opens a second copy of the same spreadsheet.

What I am striving to achieve is 2 different, but related, Spreadsheets side by side on my Desktop so that I can Compare and Contrast, as it were.

  VoG II 20:24 22 May 2008

What I would do is copy the two sheets into the same workbook. With both workbooks open, right click a sheet tab and select Move or Copy. In 'To book:' select the other workbook, tick 'Create a copy' and click OK. You can then use the method that I gave in my first click here.

  wee eddie 20:51 22 May 2008

Tomorrow I shall create a new SS, just to see if it works, and Copy both SSs onto separate worksheets, to avoid my mucking up the original.

  Woolwell 21:22 22 May 2008

IN XL 2003 my method seems to do what you want.

  wee eddie 12:47 24 May 2008

I just printed one of them out.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?