+ Reply to Thread
Results 1 to 2 of 2

Adjust Rows and Columns to Fit Ratio of a 8.5 x 11 Sheet of Paper

Hybrid View

  1. #1
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Adjust Rows and Columns to Fit Ratio of a 8.5 x 11 Sheet of Paper

    I am having a hard time wrapping my head around this one. I am basically trying to create a template that i can fill out and print onto a sheet that i have to fill out by hand. I am not going to reproduce the entire sheet because then it would not be the official document we have to turn in. My thought is, to layout an excel document and line up the cells to best match the physical document so when i fill it out, it will print in the appropriate places onto the real document i need to fill out.

    I know i need at least 60 columns and 50 rows to have enough cells to work with (can be more if need be for the proper ratio). My question is, is there a way to evenly adjust the row height and column width to match the ratio of a 7.5" x 10" paper (8.5x11 with 1" margins). I could do trial and error by adjusting it, printing it, checking it to original, repeat....but that would waste a lot of paper.

  2. #2
    Forum Contributor PY_'s Avatar
    Join Date
    09-23-2008
    Location
    Houston
    MS-Off Ver
    Office 2016
    Posts
    289

    Re: Adjust Rows and Columns to Fit Ratio of a 8.5 x 11 Sheet of Paper

    I forgot to add: I want the layout to be in landscape so the 60 columns will be along the 11" side of the paper.

+ 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. Linking Tables- Rows/columns automatically adjust
    By Jaspal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 12:58 PM
  2. Replies: 0
    Last Post: 11-08-2012, 05:05 PM
  3. [SOLVED] Automattically adjust code when rows or columns are added
    By Tulipo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2012, 05:28 PM
  4. [SOLVED] Divide x/y should give Ratio x:y,How to express ratio in excel
    By arvind3738 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2006, 03:29 AM
  5. Replies: 1
    Last Post: 08-25-2005, 07:05 PM

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