Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Use measurement rulers on a worksheet
 

Microsoft Office Excel 2007 provides a horizontal and vertical ruler in the Page Layout view, and you can use these rulers to measure the width and height of items in a worksheet. By default, the rulers use the measurement units that are specified for your computer's operating system, but you can change the units to inches, centimeters, or millimeters.

What do you want to do?


Measure the width and height of items in a worksheet

  1. On the View tab, in the Workbook Views group, click Page Layout.

    Workbook Views group on Excel Ribbon

     Tip   You can also click the Page Layout button Button image on the status bar.

  2. Use the horizontal and vertical ruler to measure items in the worksheet (such as column width, row height, or the width and height of pages).

Top of Page Top of Page

Change the ruler units

  1. Click the Microsoft Office Button Button image, click Excel Options, and then click the Advanced category.
  2. Under Display, in the Ruler units box, click the units that you want to use.

Top of Page Top of Page

advertisement