Excel Worksheets

  gagada 16:57 11 Feb 2006
Locked

I have just opened a workbook in Excel which has six worksheets.In order to compare figures on different sheets, how do I open all six worksheets at the same time?

Gagada

  VoG II 17:05 11 Feb 2006

If you use Window|New window this will open a new window and you can select a different sheet in it. You can then use the Restore down button at the top right of the window and drag the sides to make the window smaller. Do this with the second window and then arrange them side by side.

In principle you could do this with all 6 sheets but I think that would be messy.

Personally, to compare 6 sheets I would print them out.

  VoG II 17:16 11 Feb 2006

With pictures click here

  gagada 18:54 11 Feb 2006

Thanks to VoG,this works well,and arranging windows allows me to see sheets side by side.
Thanks

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Interview: Camille Walala on her giant 3D installation inspired by childhood funfair visits

Best iPad buying guide 2017

Où regarder le British Open 2017 ?