+ Reply to Thread
Results 1 to 6 of 6

Thread: Need to print a grid

  1. #1
    Registered User
    Join Date
    04-25-2007
    Posts
    24

    Need to print a grid

    I want to print a form with all the column and row lines. I want to create very specific column width and row height dimensions. It will have column headings and row items printed in the A column. How can I do this?

    Thanks

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007, 2010
    Posts
    25,773

    Re: Need to print a grid

    File > Page Setup, Sheet tab, tick Gridlines
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,791

    Re: Need to print a grid

    or format/cell /borders and create the grid lines in that
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    04-25-2007
    Posts
    24

    Re: Need to print a grid

    Thank you for you help.

    I now understand how to put the gridlines in but I don't see hor I can determine their size.

    I want a grid that is 9 columns wide and 30 rows deep and I would like this grid to take up 95% of the availble space on a normal sheet of paper.


    Thanks again

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    10,791

    Re: Need to print a grid

    youl just have to drag them about a bit ,look in print preview untill it looks about right
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and a dabbler in Cisco
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  6. #6
    Forum Guru Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007
    Posts
    3,523

    Re: Need to print a grid

    This might be of interest: Graph paper Template

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0