ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I make the page split into 2, and have them the same? (https://www.excelbanter.com/excel-discussion-misc-queries/252940-how-do-i-make-page-split-into-2-have-them-same.html)

KB84

How do I make the page split into 2, and have them the same?
 
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

How do I make the page split into 2, and have them the same?
 
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

trip_to_tokyo[_3_]

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

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.



All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com