ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Grid Boxes (https://www.excelbanter.com/excel-discussion-misc-queries/87879-grid-boxes.html)

Humbertt

Grid Boxes
 
I'm trying to create graph paper (one inch square boxes) using excel.
However, excel uses pixels to change row and column widths. I've got real
close but when i print the graph sheets and measure with a ruler its not a
one inch square box. Any ideas how to approach this or how to make one inch
square cells? thanks inadvance.

Peo Sjoblom

Grid Boxes
 
Any particular reason you need Excel for this, it's freely available online

http://www.mathematicshelpcentral.com/graph_paper.htm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Humbertt" wrote in message
...
I'm trying to create graph paper (one inch square boxes) using excel.
However, excel uses pixels to change row and column widths. I've got real
close but when i print the graph sheets and measure with a ruler its not a
one inch square box. Any ideas how to approach this or how to make one
inch
square cells? thanks inadvance.




Ardus Petus

Grid Boxes
 
With font Arial 10 (default)

with yourRange
.RowHeight=72
.ColumnWidth=13
end with

produces 72x72 points squares.

HTH
--
AP

"Humbertt" a écrit dans le message de
news: ...
I'm trying to create graph paper (one inch square boxes) using excel.
However, excel uses pixels to change row and column widths. I've got real
close but when i print the graph sheets and measure with a ruler its not a
one inch square box. Any ideas how to approach this or how to make one
inch
square cells? thanks inadvance.




Humbertt

Grid Boxes
 
thanks

"Humbertt" wrote:

I'm trying to create graph paper (one inch square boxes) using excel.
However, excel uses pixels to change row and column widths. I've got real
close but when i print the graph sheets and measure with a ruler its not a
one inch square box. Any ideas how to approach this or how to make one inch
square cells? thanks inadvance.



All times are GMT +1. The time now is 07:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com