How can I view 2 worksheets in 1 screen?

  • Thread starter Thread starter rullean
  • Start date Start date
R

rullean

Guys,

I know how to arrange 2 workbooks in 1 screen. We just need to use th
arrange function.

But, how do we arrange the worksheets so that it looks like it is a
arranged workbook?

Like, I want to view sheet 1 and sheet 2 in 1 screen just like when yo
view 2 workbooks arranged horizontally or vertically...

Is there such a way?

Thanks.

Rullea
 
I know how to arrange 2 workbooks in 1 screen. We just need to use the
arrange function.

But, how do we arrange the worksheets so that it looks like it is an
arranged workbook?

Like, I want to view sheet 1 and sheet 2 in 1 screen just like when you
view 2 workbooks arranged horizontally or vertically...
Click to expand...


Window | New Window -> minimize the Spreadsheet Window
then choose another register and arrange the both windows.

--
Regards

Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)
 
Dave said:
Hi Rullean

Go to Window>New Window as many times as the # of Sheet you wish to
view at once. Now simply go to Window>Arrange but ensure you check
"Windows of active workbook".
Click to expand...

Dave
I'm so blind -> more coffee required:-)

for the OP: ignore my previous post!
Frank
 
Back
Top