Reply to thread

Message

<blockquote data-quote="DEFCON 1" data-source="post: 5704571" data-attributes="member: 7006">The other method that I use that doesn't involve having to get or learn a new piece of software is to use Microsoft Excel.&nbsp; What I mention below is based upon using US 8 1/2 x 11&quot; paper and not A4... but assume you can adjust the margins differently so that the results are the sameYou first start by opening a New Excel spreadsheet and then go in to change the margins.&nbsp; Since we want 1&quot; squares... you set the left and right margins at 0.25&quot;.&nbsp; This gives us 8&quot; of usable left-right space.&nbsp; (8 1/2&quot; wide paper - .5&quot; from both margins = 8&quot;).&nbsp; Then, set the top and bottom margins at .5&quot; (giving us 11&quot; long paper - 1&quot; of margins = 10&quot;).&nbsp; Your printable area on each sheet is now 8&quot;x10&quot; (or 8 squares by 10 squares).Next, you highlight the entire sheet and expand the columns just enough such that you get 8 columns per page.&nbsp; For my Microsoft Excel 2003... that ends up at 9.89 column width (96 pixels).&nbsp; You then expand the rows to get exactly 10 rows per sheet (for me it's 72 row height or 96 pixels).&nbsp; This will give you sheets that are 8 columns by 10 rows out to the edges of the margins, or rows/columns that are each 1&quot; square (or nearest you're going to get).&nbsp; Save this sheet as your template.From then on... all you need to do is open a map image into the template sheet, then expand the map as big as you need so that the map's gridlines are as close to matching the spreadsheet's gridlines as possible through as much of the map as possible.You thus have expanded your map to get its grid to 1&quot; squares, and when you then print it, you'll get the map split up onto individual 8 1/2&quot; x 11&quot; sheets that you can then trim the margins off of and scotchtape together.***It's a little bit of work, but its the easiest way I've found to expand maps to 1&quot; grids without spending any money on any other printing or 'shopping programs.</blockquote>

[QUOTE="DEFCON 1, post: 5704571, member: 7006"] The other method that I use that doesn't involve having to get or learn a new piece of software is to use Microsoft Excel. What I mention below is based upon using US 8 1/2 x 11" paper and not A4... but assume you can adjust the margins differently so that the results are the same You first start by opening a New Excel spreadsheet and then go in to change the margins. Since we want 1" squares... you set the left and right margins at 0.25". This gives us 8" of usable left-right space. (8 1/2" wide paper - .5" from both margins = 8"). Then, set the top and bottom margins at .5" (giving us 11" long paper - 1" of margins = 10"). Your printable area on each sheet is now 8"x10" (or 8 squares by 10 squares). Next, you highlight the entire sheet and expand the columns just enough such that you get 8 columns per page. For my Microsoft Excel 2003... that ends up at 9.89 column width (96 pixels). You then expand the rows to get exactly 10 rows per sheet (for me it's 72 row height or 96 pixels). This will give you sheets that are 8 columns by 10 rows out to the edges of the margins, or rows/columns that are each 1" square (or nearest you're going to get). Save this sheet as your template. From then on... all you need to do is open a map image into the template sheet, then expand the map as big as you need so that the map's gridlines are as close to matching the spreadsheet's gridlines as possible through as much of the map as possible. You thus have expanded your map to get its grid to 1" squares, and when you then print it, you'll get the map split up onto individual 8 1/2" x 11" sheets that you can then trim the margins off of and scotchtape together. *** It's a little bit of work, but its the easiest way I've found to expand maps to 1" grids without spending any money on any other printing or 'shopping programs. [/QUOTE]

Verification