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

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.

KB84 wrote:

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

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.



"KB84" wrote:

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