×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

The Perfect Excel Font

The Perfect Excel Font

The Perfect Excel Font

(OP)
Is there such a thing as a perfect font for excel?

Compare the fonts shown below.
DejaVu Serif distinguishes between I and l (I and l) and allows good superscripts using standard characters (not using superscript character formatting).
(Unfortunately DejaVu Sans Serif loses the loses the distinction between I and l. )

1lI0O¹⁵     Arial
1lI0O¹⁵     Arial Unicode
1lI0O¹⁵     DejaVu Serif
1lI0O¹⁵     Tahoma
1lI0O¹⁵     Trebuchet

So for engineering spreadsheets where you need clarity for writing equations DejaVu Serif looks like a good choice.
 

RE: The Perfect Excel Font

Sure, it's called Mathcad winky smile

Excel is a rather poor tool for writing equations, don't you think?  I would even use Word's Equation Editor over Excel for something like that.  Since it comes with Office, that should be the tool of choice, particularly since it's free.  

The alternatives would be:

>  the full-blown MathType package from Design Science, from whic MS got Equation Editor
>  Mathlook for Excel from UTS: http://www.uts.us.com/ItemDetails.asp?ItemID=1100-40-0000-00

Mathlook's something that can be directly integrated with Excel.  There are probably a couple of other packages that are around.

One obvious issue is that you probably shouldn't be using a single typeface for everything, as well as avoiding mixing text and variables in the same cells.

But, since I use Mathcad practically every day, that's my tool of choice.

TTFN

FAQ731-376: Eng-Tips.com Forum Policies

RE: The Perfect Excel Font

I can't say that any particular font is perfect for every spreadsheet that I create.  In fact, at times I'll have different fonts in the same spreadsheet.  Mathcad ($1195) is a bit rich for me, so I'll have to continue to use excel, the "poor" man's tool.  I also use ExcelCalcs addin (can be free) to display my equations.  I think it's tough to beat.upsidedown

http://www.excelcalcs.com/

View Clyde's profile on LinkedIn

RE: The Perfect Excel Font

I generally use the equation editor to document equations, not too difficult and full featured. Works with virtually any popular font in both Word or Excel. Sometimes I document using hand written sketches or equations, scanned and inserted. Cheap and low tech, but has that personal touch and nobody has complained yet. MathCad might be good, but in 25 years, I have only seen it used once by a bridge engineer. None of the civils I know use it, they virtually all use plain, vanilla Excel. Since none of our clients have mathcad, this is probably for the best. Most of the structurals I have worked with still do hand written calcs.  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources