Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2011, 07:53 PM
Foppa Foppa is offline Creating a Folding "Book style" Layout for Print? -Excel 2007 Windows 7 32bit Creating a Folding "Book style" Layout for Print? -Excel 2007 Office 2007
Novice
Creating a Folding "Book style" Layout for Print? -Excel 2007
 
Join Date: Sep 2011
Posts: 11
Foppa is on a distinguished road
Default Creating a Folding "Book style" Layout for Print? -Excel 2007

I need to create a program handout for an event and I want to do it in Excel.



I'm looking for some help to figure out how to set it up. Maybe even step by step instructions if one is willing

It needs to be landscape, will be folded in half and will open up like a book.

Inside, I will need to fill in left content and right content (again, like a book, birthday card, etc..). Both sides will be laid out the same with a centered header at the top and the content below.

The content under the header will simply be as follows (on both the left and right sides):

Chorister......................................... .......(Name)

Pianist........................................... ........(Name)

etc...


Any help would be greatly appreciated. Thanks!
Reply With Quote
  #2  
Old 09-12-2011, 11:09 PM
Catalin.B Catalin.B is offline Creating a Folding "Book style" Layout for Print? -Excel 2007 Windows Vista Creating a Folding "Book style" Layout for Print? -Excel 2007 Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

you have to format your worksheet as you like, then go to printer properties, and select two pages per sheet, and duplex, if your printer allows that..
Reply With Quote
  #3  
Old 09-13-2011, 01:25 AM
OTPM OTPM is offline Creating a Folding "Book style" Layout for Print? -Excel 2007 Windows 7 32bit Creating a Folding "Book style" Layout for Print? -Excel 2007 Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
To add to what Catalin has said which is perfectly correct as far as printing is concerned. However once you have your content designed and produced you will need to carry out the following steps (depending on how many pages you have to print):
1. Make a mock up of you book and mark each page with the page number.
2. The you will need to re-order your pages in Excel so that they print on the right side of the two page printout from Excel.
For example if you have an eight page book to print out each printed sheet (assuming double sided printing is used) will have the following pages printed on them:
Sheet 1 - Side 1:
Page 1 and 8
Sheet 1 - Side 2:
Page 2 and 7
Sheet 2 - Side 1:
Page 3 and 6
Sheet 2 - Side 2:
Page 4 and 5
Hope this helps.
Good luck.
Tony(OTPM)
Reply With Quote
Reply

Tags
book layout, folding card

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a Folding "Book style" Layout for Print? -Excel 2007 "Table of content" based on "Normal Style" behavior!!!! Jamal NUMAN Word 4 07-08-2011 04:12 AM
Creating a Folding "Book style" Layout for Print? -Excel 2007 Word 2010: "Screen shot" and "Print Screen" and fitting the page boundaries! Jamal NUMAN Word 4 06-30-2011 05:48 PM
Creating a Folding "Book style" Layout for Print? -Excel 2007 How the "Style" and the "List" are linked?? Jamal NUMAN Word 1 06-30-2011 05:18 PM
Creating a Folding "Book style" Layout for Print? -Excel 2007 (again): the mark of index is very confusing!!!!! "Print layout" - Print Preview!! Jamal NUMAN Word 4 06-30-2011 01:08 AM
"Microsoft Excel Application" missing in the "Component Services" on win08 sword.fish Excel 0 02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft