How to View the Ruler in Excel 2010

When you are adjusting the settings on a spreadsheet in Excel 2010, one of your biggest concerns may revolve around how to page looks when it is printed. While we have previously written about ways to fit a spreadsheet on one page and how to repeat a row at the top of a page, you may be more concerned with appropriately sizing your cells to fit a specific criteria. Unfortunately this can be difficult to do visually, so Excel has included a ruler that you can turn on and off to help you with accurate sizing. But that ruler is not visible in every view, so you need to make some additional changes to view the ruler in Excel 2010.


How to Show the Ruler in Excel 2010

Switching views in Excel 2010 allows you to make some additional changes and view some additional areas of your spreadsheet that you may not have otherwise been able to see. The Excel 2010 ruler is available in one of these different views, and is likely the reason that you haven’t been able to find or see the ruler. So continue reading below to learn how to enter the correct view and enable the ruler.


Step 1: Open your spreadsheet in Excel 2010.


Step 2: Click the View tab at the top of the window.

click the view tab



Step 3: Click the Page Layout button in the Workbook Views section at the left side of the window.

how to view the ruler in excel 2010



Step 4: Check the box to the left of Ruler in the Show section of the ribbon at the top of the window.

click the ruler option



You should now see a ruler at the top and left side of the window. Additionally, note that if you select any of the other view options in the Workbook Views section, the ruler will disappear. The box will remain checked in the Show section of the ribbon, but it is grayed out in every view except the Page Layout view.


Have you been thinking about upgrading to a newer version of Excel, or do you need to install it on other computers? The Office 365 subscription is a less expensive option in many situations. Click here to learn more about it. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.