ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I arrange multiple spreadsheets on one page? (https://www.excelbanter.com/excel-discussion-misc-queries/66474-how-do-i-arrange-multiple-spreadsheets-one-page.html)

Rob D

How do I arrange multiple spreadsheets on one page?
 
I have five separate spreadsheets each with varying columns. How do I place
them on one page for entry, viewing and printing? Using Excel 2003.

Bernard Liengme

How do I arrange multiple spreadsheets on one page?
 
Use the command Window | New Window, followed by Window | Arrange -
vertical
Now you have two views on the same sheet, so on one click on Sheet2's tab
Repeat to see 5 sheets in one window (not on one 'page")
You might need to click and drag the Title bars to get the right sequence in
the window

Hope you have a B...I...G screen
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rob D" <Rob wrote in message
...
I have five separate spreadsheets each with varying columns. How do I
place
them on one page for entry, viewing and printing? Using Excel 2003.





All times are GMT +1. The time now is 12:48 PM.

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