Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mirroring
 
Posts: n/a
Default How can I mirror pages in an excel document for printing?

I have 300 pages in an excel document which need to be double sided and bound
into a a publication. I need to mirror the pages so they have the same
margin on both left and right depending where they fall in the document. Can
anyone help please?
  #2   Report Post  
Michael
 
Posts: n/a
Default

Hi
File / Page Setup / Margins......set left and tight margins to equal amounts.
You might also try ticking the centering check boxes.

HTH
Michael

"mirroring" wrote:

I have 300 pages in an excel document which need to be double sided and bound
into a a publication. I need to mirror the pages so they have the same
margin on both left and right depending where they fall in the document. Can
anyone help please?

  #3   Report Post  
Michael
 
Posts: n/a
Default

Sorry
A typo.......make that Left and Right margins.

"mirroring" wrote:

I have 300 pages in an excel document which need to be double sided and bound
into a a publication. I need to mirror the pages so they have the same
margin on both left and right depending where they fall in the document. Can
anyone help please?

  #4   Report Post  
Shazza
 
Posts: n/a
Default

Hi Michael

Our print department mentioned centering would be better as well, could you
explain how this would be better? I imagined that it would make the left
margin smaller than the right margin and look a bit off centre once the
document has been bound.

In Microsoft Word, there is a setting to mirror the margins and the program
calculates for you which pages need to be right aligned and left aligned.

Appreciate your help!!

Kind regards
Sharon

"Michael" wrote:

Sorry
A typo.......make that Left and Right margins.

"mirroring" wrote:

I have 300 pages in an excel document which need to be double sided and bound
into a a publication. I need to mirror the pages so they have the same
margin on both left and right depending where they fall in the document. Can
anyone help please?

  #5   Report Post  
Michael
 
Posts: n/a
Default

Hi Shazza
You're correct in assuming that it would make the left smaller than the right.
However,by centering your sheets you will ensure that everything is captured
on the page.
If all pages are identical, then you could set your margins without
centering, print the first page and then go from there.
If there is any doubt go back to the centering method.
You could also look at your printer options. Some printers allow for
printing of bound documents.

HTH
Michael

"Shazza" wrote:

Hi Michael

Our print department mentioned centering would be better as well, could you
explain how this would be better? I imagined that it would make the left
margin smaller than the right margin and look a bit off centre once the
document has been bound.

In Microsoft Word, there is a setting to mirror the margins and the program
calculates for you which pages need to be right aligned and left aligned.

Appreciate your help!!

Kind regards
Sharon

"Michael" wrote:

Sorry
A typo.......make that Left and Right margins.

"mirroring" wrote:

I have 300 pages in an excel document which need to be double sided and bound
into a a publication. I need to mirror the pages so they have the same
margin on both left and right depending where they fall in the document. Can
anyone help please?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help, insert a word document contents into excel tab? Dan Ward Excel Discussion (Misc queries) 2 December 15th 04 12:01 AM
Is it possible to link an Excel spreadsheet to a Word document an. Infinity Excel Discussion (Misc queries) 1 December 14th 04 03:30 PM
getting specific info from a word document into excel smintey Excel Discussion (Misc queries) 3 December 8th 04 08:20 PM
Getting specific data from a word document into an excel sheet smintey Excel Worksheet Functions 3 December 7th 04 05:17 PM
excel cannot open .xls the document may be read only or encrypted mukesh Excel Discussion (Misc queries) 0 November 27th 04 12:35 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"