How do I make the page split into 2, and have them the same?

[KB84]

I want to make landscape A4 page, split into 2 down the middle, and have the
same information on the left as the right.

 

[Dave Peterson]

Maybe you could experiment with something like:

Select the range for the left hand side (say A1:E20).
Edit|Copy (in xl2003 menus)

Select F1
and shift-Edit|Paste Picture Link

Anything you change in the left hand side will change on the picture on the
right hand side.

 

[trip_to_tokyo]

In EXCEL 2007 take the following actions:-

Page Layout

Page Setup group

Orientation

Landscape

Click in cell I 1

View

Window group

Split

You should now have what you want.

If my comments have helped please hit Yes.

Thanks.