Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 3rd 08, 04:11 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 2
Default Forcing Same Output Regardless of Printer

I am teaching summer school, and we have to turn in attendance in a certain
format, so I have created an Excel WB to help me. On my computer/printer
combination, everything is fine. I even locked some of the pages/cells to
that other teachers I share this with can't screw it up.

However, for some teachers who are using my WB to do their attendance, when
they print, the last column is chopped off and ends up being printed on a
separate page, which creates a bunch of extra work for the secrataries
processing the forms. They of couse can't change the column widths since
edits are locked. Also, when they send it to me to fix (since I can obviously
unlock the pages and edit) I don't know how far to shrink the column, since
it looks fine on my computer/printer without shrinking.

Right now, the margins are set at 0.25" all around, with 0.50" for header
and footer. I'm guessing that some printers can't print that close to the
edge of the paper, but how can I possibly anticipate that before hand with a
WB which I am distributing to other users?

Thanks!


  #2   Report Post  
Old July 3rd 08, 05:00 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Forcing Same Output Regardless of Printer

Have you tried FilePage SetupPage

Fit to: 1 page wide by "more than you need" pages tall


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 08:11:03 -0700, Jay Windley
wrote:

I am teaching summer school, and we have to turn in attendance in a certain
format, so I have created an Excel WB to help me. On my computer/printer
combination, everything is fine. I even locked some of the pages/cells to
that other teachers I share this with can't screw it up.

However, for some teachers who are using my WB to do their attendance, when
they print, the last column is chopped off and ends up being printed on a
separate page, which creates a bunch of extra work for the secrataries
processing the forms. They of couse can't change the column widths since
edits are locked. Also, when they send it to me to fix (since I can obviously
unlock the pages and edit) I don't know how far to shrink the column, since
it looks fine on my computer/printer without shrinking.

Right now, the margins are set at 0.25" all around, with 0.50" for header
and footer. I'm guessing that some printers can't print that close to the
edge of the paper, but how can I possibly anticipate that before hand with a
WB which I am distributing to other users?

Thanks!


  #3   Report Post  
Old July 3rd 08, 05:41 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Forcing Same Output Regardless of Printer

Another option:

You could do an exhaustive review of every printer (and potential printer!) that
could be used.

Or you could just bite the bullet and make your margins as bad(!) as you can
guess will be used.

You may find that Gord's suggestion works fine. But if you added manual
horizontal pagebreaks, you may find changing your margins works better.



Jay Windley wrote:

I am teaching summer school, and we have to turn in attendance in a certain
format, so I have created an Excel WB to help me. On my computer/printer
combination, everything is fine. I even locked some of the pages/cells to
that other teachers I share this with can't screw it up.

However, for some teachers who are using my WB to do their attendance, when
they print, the last column is chopped off and ends up being printed on a
separate page, which creates a bunch of extra work for the secrataries
processing the forms. They of couse can't change the column widths since
edits are locked. Also, when they send it to me to fix (since I can obviously
unlock the pages and edit) I don't know how far to shrink the column, since
it looks fine on my computer/printer without shrinking.

Right now, the margins are set at 0.25" all around, with 0.50" for header
and footer. I'm guessing that some printers can't print that close to the
edge of the paper, but how can I possibly anticipate that before hand with a
WB which I am distributing to other users?

Thanks!


--

Dave Peterson


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
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
Printer Multiple Worksheets with a particular Printer Setting PP[_2_] Excel Worksheet Functions 0 March 14th 07 03:02 PM
Forcing SaveAs to new name Rob Excel Discussion (Misc queries) 2 December 3rd 06 06:14 AM
Excel document printer properties overwrite users output bin joost Excel Discussion (Misc queries) 0 November 8th 06 09:27 AM
forcing UDF to run Stefi Excel Worksheet Functions 4 December 29th 05 04:46 PM


All times are GMT +1. The time now is 09:51 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017