How to display the Ruler bar in Excel

Excel's Ruler bar was accidentally hidden, making it difficult for you to adjust the table size. So how to retrieve the Ruler?

The Ruler bar in Excel is similar to the Ruler bar on Word, used to align content or presentation tables. By default this Ruler ruler will always be displayed on the interface. But by accidentally setting up a mistake, the Ruler bar on Excel has been hidden. This will make it difficult for users to align the margins on Excel, resize columns and lines on Excel. So how to re-display the Ruler bar in Excel?

  1. How to display Ruler ruler bar in Micorosoft Word
  2. How to scroll bar scrolls horizontally and vertically in Word and Excel
  3. Word 2013 Complete Guide (Part 6): Aligning page layout

Instructions for displaying Ruler bar on Excel

Step 1:

At the main interface of Excel, click on the View tab on the ribbon bar.

How to display the Ruler bar in Excel Picture 1How to display the Ruler bar in Excel Picture 1

Step 2:

Continue to look down below click on the Page Layout item . Then, select the Ruler box to re-display the ruler bar in Excel.

How to display the Ruler bar in Excel Picture 2How to display the Ruler bar in Excel Picture 2

The ruler bar displayed on Excel will display on the top and left side of the interface.

How to display the Ruler bar in Excel Picture 3How to display the Ruler bar in Excel Picture 3

You can customize the size, align the left and right of the content.

How to display the Ruler bar in Excel Picture 4How to display the Ruler bar in Excel Picture 4

Or use the ruler to align the top and bottom margins for the page. The size unit will be placed cm. If not at cm you can change the current Excel size to cm, in the Ruler units section. Each time you move the measure will display the current number of centimeters.

How to display the Ruler bar in Excel Picture 5How to display the Ruler bar in Excel Picture 5

Using the Ruler ruler on Excel will help users align the top and bottom sides more accurately. Excel versions use the above method to re-display the Ruler ruler bar.

See more:

  1. How to adjust the size of Word table cells equally
  2. How to equalize line, column, and cell sizes in Excel
  3. Line breaks in Excel

I wish you all success!

4 ★ | 19 Vote