While working in Excel, we may want the Ruler to show up on the top and left side of the worksheet. It helps to resize the Row Height or Column Width precisely as we wish. But in the typical Excel sheet view, the ruler doesn’t appear automatically. We can fix it easily. In this article, I will show the easy solution to fix the problem if the ruler in Excel not showing automatically.
Download Practice Workbook
You can download the practice workbook from here to exercise.
The Function of Ruler in Excel
The Ruler is the scale that remains present on top of Row and on the left side of Column in an Excel worksheet. It helps to determine the exact Row height or Column Width. The measurement scale of the Ruler can also be changed to different units as per our requirement. In the normal view of Excel, the ruler is not present. But we can easily fix that by following simple steps.
Step-by-Step Solution When Excel Ruler Is Not Showing
In the normal view of the Excel sheet, the Ruler is not present. If we check on the View tab, we will see the Ruler option is greyed out like in the picture below, which means we can’t select it. No need to worry, we have an easy solution for the problem. In this section, I will show the solution with easy steps when Excel Ruler is not showing.
STEP 1: Activate the Worksheet
- For showing the Ruler in Excel sheet, we have to open an Excel sheet first. For the demonstration purpose, I have introduced a dataset having Player and Goal in Match 1, Match 2 and Match 3.
- In the worksheet, we won’t see the Ruler on top or left side of the worksheet.
STEP 2: Select View Tab
- Now, for showing the Ruler in Excel we need to select the View tab in the Excel ribbon.
- Therefore, we will see some features of the View tab.
- Moreover, we will see the Ruler option is greyed out.
- No need to worry. I will show the solution for activating the Ruler option in the following steps.
- Remove Last Modified By in Excel (3 Ways)
- How to Move Up and Down in Excel (5 Easy Methods)
- Make a Dot Plot in Excel (3 Easy Ways)
- How to Make a Box Plot in Excel (With Easy Steps)
- Show Menu Bar in Excel (2 Common Cases)
STEP 3: Find Page Layout
- So that our active sheet is in Normal View mode, we can’t select the Ruler option.
- For activating the Ruler option, we have to select the Page Layout in the View tab too.
- Now, we will see the Ruler option is not greyed out anymore.
STEP 4: Select Ruler
- Finally, as the Ruler option is activated we need to put a tick mark on the Ruler option.
- Consecutively, we will see the Ruler appear on the top and left side of our active worksheet.
- Hurrah! We have successfully included the Ruler on the top and left side of our worksheet.
- Therefore, we can change the size of any cell or column as well as any row with a definite length as the Ruler is present on the left side.
How to Change Unit of Ruler in Excel
In the previous section, I have shown the procedure to show the Ruler in Excel. The measurement scale of the Ruler is Inches. But we may want to change the Ruler measurement changed to another unit. It’s quite simple to change the unit of the Ruler. Please, follow the steps given below for changing the Ruler unit.
- Firstly, we have to select the File option on the top left corner of the Excel ribbon.
- Afterward, from the expanded window we select the Options which is at the bottom of the list.
- Further, from the Excel Options window select the Advanced option.
- Later on, scroll to the Display section on the right side of the window.
- In addition, select the drop-down icon beside the Ruler Units option.
- Furthermore, select the ruler unit as you require. I have chosen Centimeters as the new ruler unit.
- Finally, press OK.
- Now, come back to the worksheet and we will see the Ruler Unit changed to Centimeters.
The Ruler in Excel is quite useful for measuring the size of any Cell or Column Width or Row Height from a worksheet. In this article, I have shown the solution with easy steps if the Ruler in Excel is not showing. I hope, this article will help you to show the Ruler in the active worksheet. If you have any queries about the procedure, feel free to make comments below. Please, visit our ExcelDemy site for similar articles regarding Excel.
- How to Create Toggle Button on Excel VBA UserForm
- Create a Word Cloud in Excel (2 Easy Ways)
- How to Show Full Cell Contents on Hover in Excel (5 Quick Ways)
- Mark Workbook as Final in Excel (with Easy Steps)
- Search Text in Multiple Excel Files (2 Easy Ways)
- How to Color Code Cells in Excel (3 Efficient Methods)
- Fix Formula in Excel (9 Easy Methods)