MS Excel for Range Sticks

Started by T13A, 21 February 2025, 10:56:46 AM

Previous topic - Next topic

T13A

Hi

I'm using MS Excel to make some 'range'sticks' for a set of rules; just wondering if anybody knows what the measurments in Excel when resizing a 'cell' equate to in real life (i.e. when I print something out). Currently showing a cell is 5.11 (53 pixels) wide. But 5.11 is what exactly?  :-\  :(

Any help gratefully received!

Cheers Paul
T13A Out!

fred.

Do you have access to Word? As in it you can define table cells in real world measurements 

I don't recall being able to do this in excel. 

Old school was 72dpi for screen resolution- which means 72 dots (pixels) per inch. 
2011 Painting Competition - 1 x Winner!
2012 Painting Competition - 2 x Runner-Up
2016 Painting Competition - 1 x Runner-Up!
2017 Paint-Off - 3 x Winner!

My wife's creations: Jewellery and decorations with sparkle and shine at http://www.Etsy.com/uk/shop/ISCHIOCrafts

Last Hussar

Yeah, I'd go Word. You can tell the computer how big to make something easily.
I have neither the time nor the crayons to explain why you are wrong.

"The test of our progress is not whether we add more to the abundance of those who have much; it is whether we provide enough for those who have too little."
Franklin D. Roosevelt

GNU PTerry

Lord Kermit of Birkenhead

Certainly I use Word tables to make Saga dice ship lables. You do have to ensure that the objectwill fit the cells as they will resize to fit it. Also occasionally the object will rotate.
FOG IN CHANNEL - EUROPE CUT OFF
Lord Kermit of Birkenhead
Muppet of the year 2019, 2020 and 2021

d_Guy

IIRC you can change the dimensional units of cells in Excel. I am not at my desktop but try a search on help or do a google search. I used this feature to make labels using mm dimensions some time ago
Encumbered by Idjits, we pressed on

Ithoriel

I use Open Office rather than MS but it can certainly size cells to a specific mm size. Like d_Guy I use it regularly to make labels for wargames units/ ships/ etc.
There are 100 types of people in the world, those who understand binary and those who can work from incomplete data