+ Reply to Thread
Results 1 to 2 of 2

Changing the Print Size

  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    Somersworth,NH
    MS-Off Ver
    2010
    Posts
    1

    Changing the Print Size

    The Situation: I am currently working with my local police department to upgrade there finger printing systems. Rather than fill out 6 forms by hand that all contain the same information I set up a spreadsheet that takes in information in one sheet and other sheets access it, in this way officers fill in 30 fields in one sheet and all that needs to be done is print the other sheets. I know there are software programs that deal with pre-filled forms but my budget is 0$ and my only equipment is an old brother printer. I took a scanned image of the forms and overlayed the text across those. The height and width of the image is 8x8 which is the same as the special card stock I have to print on. I have set the print area exactly to the image with the text, I have changed the paper size in the printer preferences, and I have no margins. I need the print to be border less which my printer does not support, I have gotten around this by fooling the printer into thinking that it is exactly .15 in bigger than it is. When ever I try to scale the print horizontally (Fit all columns on to one page) it comes out in the perfect spots horizontally but not vertically, I am always about half an inch off. Whenever I change the scale vertically (Fit all rows on to the page) it chops off the right end. I don't want to mess with the image because it is at 8x8 and I don't want to throw off my ratio.

    My Question: Is there a way to get the print as close as possible to the edge on all sides?
    I am lost and have sunk nearly 25 man hours into trying to get this thing working, any advice or solution is welcome.
    Thank you for your time

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Changing the Print Size

    Hard to tell without testing, but have you tried PrintToFit? Maybe tell excel the printer has larger paper than it actually has?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to print PDF's in A3 size
    By sparx in forum Excel General
    Replies: 3
    Last Post: 03-06-2017, 05:13 PM
  2. Changing Page Size - Only gives label size options
    By etouch in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-31-2016, 02:40 PM
  3. Print to A3 size issue
    By Rob K in forum Excel General
    Replies: 1
    Last Post: 09-01-2015, 09:16 AM
  4. Button changing size and font size
    By jennyc2 in forum Excel General
    Replies: 1
    Last Post: 05-13-2009, 07:53 PM
  5. Print Size
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 06-05-2006, 08:00 PM
  6. [SOLVED] print view & print, in excel, different size cells
    By buddyorliz in forum Excel General
    Replies: 3
    Last Post: 09-01-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1