A Ruler in Excel

by Allen Wyatt
(last updated February 15, 2017)

4

It seems odd that Word allows you to display an on-screen ruler, but Excel does not. Perhaps it is because you can scale Excel so that you can make whatever you want fit on any size page; perhaps not. Whatever the reason, you are left to your own devices to come up with a way to "measure" whatever you place on the screen.

One way you can approach the problem is to simply use your own physical ruler to determine on-screen measurements. This may seem strange, but it works pretty well. Try this:

  1. Open a new worksheet.
  2. Change the font used in the worksheet to Courier New.
  3. Change the width of each column to 12.
  4. Place a number one (a single digit) in columns A through G.
  5. Print the sheet.

If you get out your ruler, you should find that the digits on the printed page are about one inch apart. If they are not, then you can adjust the column widths and print again, until they are very close to an inch apart.

Now, hold the ruler up to the screen and measure the distance between the digits. Reduce the zoom setting for the screen until the digits are very close to an inch apart. (On my system, I needed to set the zoom at 82%.)

That's it. You can now use the ruler to figure out horizontal measurements on the screen. Even if you change the column widths or change the font, the zoom setting is what counts. In my case, every time I set my magnification at 82%, I can rest assured that what I see on screen is a very close approximation of what will print.

You can also use the same general approach to create your own graphic ruler. For instance, you could use a screen capture of the ruler in Word, and then size it to match the settings you made above. The graphic is "overlaid" on the screen (the same as you would do with a physical ruler), and therefore serves the same function.

Obviously, either of these workarounds takes a little trial and error. Hopefully, just about the time you get an approach figured out, Microsoft will release a version of Excel that has built-in rulers.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2484) applies to Microsoft Excel 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Inserting a Row or Column

When editing worksheets, it is important to know how to add rows and columns. Excel provides a couple of quick ways you can ...

Discover More

Duplicate Workbooks Opening

If you ever open a workbook and always see two workbooks instead of one, chances are good the reason is because of the number ...

Discover More

Allowing for Words that Contain Numbers

When Excel does a spell-check of the information in a worksheet, you may want it to ignore words that contain numbers. All it ...

Discover More

Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!

MORE EXCELTIPS (MENU)

Canceling a Menu

Want to cancel whatever menu command you started to use in Excel? The normal method is by pressing Esc, but this is not the ...

Discover More

Slow Excel Response Times

Many people use Excel on a notebook computer, so they can do work at the office and elsewhere. In some situations, Excel may ...

Discover More

Excel Won't Display Different Windows in the Taskbar

If you want individual Taskbar buttons for each open Excel workbook but cannot seem to get those buttons, the culprit could ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 9 - 7?

2015-03-03 13:41:58

Alan M

Or, with Excel 2003, get JRuler.exe, and use with 'Print Preview' ?


2014-06-11 15:59:12

Michael (Micky) Avidan

@Bethany,
Can you, please, explain how this is done in the Excel versions(!) this tip refers to !?
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2014)
ISRAEL


2014-06-10 18:17:02

rw

With all this knowledge it is EXTREAMLY weird that this is suggested. it appears to even Excel with Word in #7 MS removed the ruler or made it extremely difficult to find: What up with that??????


2014-04-16 11:46:42

Bethany

Or just go to View > Page Layout.

It's not pretty, but the rulers are visible.


This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing