How to easily unhide the Ruler in Excel 2007, 2010, 2013, and 2016

When using Excel, you may accidentally hide the Ruler bar, which can be disruptive to your workflow. Don’t worry, in this article, we will show you how to unhide the Ruler bar in Excel 2007, 2010, 2013, and 2016.

What is the Ruler bar in Excel used for?

The Ruler bar in Excel is a simple tool that allows users to save time when aligning cells. In Excel, when you’re working in Page Layout view, the software provides you with a horizontal ruler and a vertical ruler. The Ruler bar enables you to measure the width and height of cells in your Excel worksheet, making it easy to adjust column widths and row heights. You can also use the Ruler to set page margins for printing.

By default, the unit of measurement for the Ruler bar in Excel depends on your computer’s operating system. However, you can change the units to inches, centimeters, or millimeters.

How to unhide the Ruler bar in Excel

If the Ruler bar is not visible in Excel, follow these steps to unhide it:

1. Quick guide

In the Excel interface, select the View tab, click on Page Layout, and check the Ruler option.

2. Detailed guide

Step 1: Click on the View tab in the Excel ribbon interface.

Step 2: Select the Page Layout view and check the Ruler option to display the Ruler bar. In addition to the Ruler, you can also toggle the display of other elements such as the Formula Bar, Headings, and Gridlines by checking or unchecking the corresponding options in Excel.

Step 3: To display the vertical Ruler, select File, followed by Options, then choose Show vertical ruler in Print Layout view under the Display section.

The result will be a Ruler bar displayed in Excel, as shown in the image below:

By default, the Ruler bar is set to inches. If you want to change the unit of measurement to centimeters in Excel, you can follow these steps:

• Step 1: Open a new Excel file and check the current unit of measurement by going to the Page Layout tab and selecting Margins in the Page Setup section.
• Step 2: Click on the File tab in the toolbar. On the File interface, select Options in the bottom left corner of the screen.
• Step 3: The Excel Options window will appear. Select the Advanced tab on the left sidebar. Scroll down to the Display section, choose Centimeters under Ruler units, and click OK to apply the changes.
• Step 4: Check the result in Excel by going to the Page Layout tab and selecting Margins in the Page Setup section. The unit of measurement should now be centimeters.

You can also refer to this article for detailed instructions on how to change inches to centimeters in Word.

3. Notes on unhiding the Ruler bar in Excel

This article provides instructions that apply to Windows 10. You can use these steps for computers running Windows or macOS.

These instructions are based on Microsoft Excel 2013, but they should work similarly for Excel versions 2007 and later.

How to hide the Ruler bar in Excel

If you no longer need the Ruler bar in Excel 2007, 2010, 2013, and 2016, you can hide it by following these steps:

Step 1: Click on the View tab in the Excel ribbon interface.

Step 2: Select the Page Layout view and uncheck the Ruler option in the Show group.

You can now continue using the default Excel interface without the Ruler bar.

Conclusion

As you can see, unhide the Ruler bar in Excel 2007, 2010, 2013, and 2016 is a straightforward process. We hope that the detailed instructions in this article will help you unhide the Ruler bar in Excel quickly and easily. Good luck!

To ensure an efficient learning and working process, it is important to have a well-configured computer. If you’re looking for a reliable, reasonably priced laptop for students or office workers, visit the FPT Shop website to explore the latest products!

• How to change a decimal point to a comma in Excel and normalize spreadsheet data quickly
• 3 ways to use the Random function in Excel that you should know