Help support TMP

"Microsoft Excell Question" Topic

14 Posts

All members in good standing are free to post here. Opinions expressed here are solely those of the posters, and have not been cleared with nor are they endorsed by The Miniatures Page.

For more information, see the TMP FAQ.

Back to the Terrain and Scenics Message Board

Back to the Maps Message Board

1,097 hits since 14 Oct 2009
©1994-2018 Bill Armintrout
Comments or corrections?

Steve Hazuka Inactive Member14 Oct 2009 8:03 p.m. PST

I would like to use Excell to draw up some floor plans and ship deck plans and I was wondering what size cell would I need to make for half inch and one inch square cells. I keep playing with it but I figured I'm not the first one to do this.

JRacel Inactive Member14 Oct 2009 8:20 p.m. PST


I live, eat and breath Excel to make a living and it is the last tool, short of MS Access I would use to make map grids. I am sure the folks around here can point you in a better direction since almost any decent art program would do this much better. Maybe there is a good way to use it for this, but for the life of me I can't think what it would be. Sorry, not trying to burst your bubble, just thinking you might do better asking about a cheap or free graphics program that can do this much better than Excel.

Best of luck,


Skrapwelder14 Oct 2009 8:23 p.m. PST

100 pixels to the inch so your cell should be 50 pixels by 50 pixels

Personal logo chicklewis Supporting Member of TMP14 Oct 2009 8:41 p.m. PST

Here's just what you need. Print graph paper with any size grid. FREE ! EASY ! I've used it many times.

(JRacel is right, Excell is CR@P for your purpose. Even uses different units for the horizontal and vertical. Excell NOT recommended)

Top Gun Ace Inactive Member14 Oct 2009 11:05 p.m. PST

Try MS Word's simple drawing program.

You can easily make squares, grids, hexes, etc. of any size. Just click on the right mouse button, and select Format Autoshape to resize as desired.

You can use English, or Metric units, as desired.

You can also use the various shapes, or the simple drawing features to permit you to draw the outer hull outline of the craft too.

mandt2 Inactive Member15 Oct 2009 7:17 a.m. PST

See if you can find an old version of Photoshop on eBay.

Personal logo Extra Crispy Sponsoring Member of TMP15 Oct 2009 7:22 a.m. PST

Powerpoint will let you create a gridded page. From that you can then add all sorts of shapes and save them as "clip art" to be used again when needed…

KenH01 Inactive Member15 Oct 2009 8:42 a.m. PST

Try this, any size and type of graph paper you can think of.

dumps to PDF format.


Ruben aka Qwirz Supporting Member of TMP15 Oct 2009 11:20 a.m. PST

I always use Photoshop for grids and Templates too.
Atlhough Autocad saves a lot of time but needs a bit more of practice. (….my wife is an Architect!)
I Have to say that Chick's link is the fastest mean to Hex grids. I still think hexes are best than squares.

Ruben aka Qwirz Supporting Member of TMP15 Oct 2009 11:23 a.m. PST

And Ken's too! The net is full of surprises!

Ditto Tango 2 1 Inactive Member15 Oct 2009 8:14 p.m. PST

Chick and Ken! Thanks so much for those great links!

BillChuck Inactive Member16 Oct 2009 5:32 a.m. PST

For drawing square-based maps, there are several programs available. Search for rpg mapmaking tools. One I know off hand is Dundjinni. There should be dome freeware programs out there as well.

Chris Wimbrow16 Oct 2009 3:16 p.m. PST

I have worked out the cell sizes to make 1/4" or 1" (within acceptable tolerances) printed cells with Excel for my printer. It's just a matter of testing, proportioning, and trial and error.

And you have the spreadsheet functionality built in.

Last Hussar22 Oct 2009 6:16 p.m. PST

AutoREALM- free mapping down load (or it was 3 years ago when I got it)

Sorry - only verified members can post on the forums.