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
File > Page Setup, Sheet tab, tick Gridlines
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
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
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
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
This might be of interest: Graph paper Template
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks