Excel 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.

Measure the width and height of items in a worksheet

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

    Tip: You can also click the Page Layout button Button imageon 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).

Change the ruler units

  1. Click File > Options > Advanced.

  2. Under Display, in the Ruler units box, click the units that you want to use.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×