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

  • Thread starter Thread starter KB84
  • Start date Start date
K

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.
 
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.
 
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.
 
Back
Top