Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11The Ruler bar in Excel is locked, the fix is extremely simple
The Ruler bar in Excel is locked and gray so you cannot use it? This is a fairly common problem for users and don't worry, because TipsMake has a solution to help you solve it.
The Ruler bar in Excel not displayed, or displayed but not usable, is a very 'familiar' situation, causing many problems for users. Because at this time, you cannot measure/align the width and height of rows according to your needs for your Excel file. What is the reason why the Ruler bar in Excel is locked and how to fix this situation? Your question has been answered in detail in today's tips section. Stay tuned for the next part!
Find out the reason why the Ruler bar in Excel is locked
Don't panic if you don't see the Ruler bar appear in the Excel file you're working with. Because this is not an error, you just accidentally hid the ruler bar. It's possible that you made a mistake in the operation so you tick the right option to hide the Ruler bar. So what about the case where the Ruler bar is gray, locked and cannot be used?
Reasons why the ruler bar in Excel does not work
There have been quite a few users wondering and confused about the locked ruler bar in Excel. Specifically, this is a situation where the Excel ruler turns gray and cannot be used. The specific reason is because:
By default, Excel's ruler can only be used in Page Layout View. Therefore, if you switch the file to Normal View and Page Break Preview, the Ruler bar will turn gray and cannot be used.
As you will see in the illustration, even if you try to tick the option to display the Ruler bar, it cannot be done. This option is dimmed and cannot be operated.
So we know why the ruler bar is locked in Excel, right? The fix is extremely simple, the following section will guide you in detail.
- Question mark font error in Excel, quick fix
- Quick method to fix Excel loop error
How to fix the locked Ruler bar in Excel super quickly
To display the Ruler bar in Excel, you just need to change the view mode, and tick the Show ruler bar checkbox and you're done.
❖ Quick instructions: View tab > Click to select Page Layout mode > Tick to select Ruler in Show.
❖ Detailed instructions:
✪ Step 1: In the open Excel file, click on the View tab.
✪ Step 2: In the Workbook Views area > Select Page Layout.
✪ Step 3: Also on the View tab, go to Show > Select the Ruler option > Thus, the ruler bar will display in Excel.
❖ Note: In this mode, if you want to hide the Ruler bar, uncheck the Ruler line!
Share more - Instructions for changing the measurement unit of the ruler bar
When you activate the Ruler bar in Excel, the software will display the ruler bar with default units. But you can completely change the measurement unit to suit your needs as follows:
✪ Step 1: In the open Excel software, click the File tab > Select the Options option in the list on the left.
✪ Step 2: Continue clicking Advanced in the items on the left in the new window displayed.
✪ Step 3: Find the display area, at the line Ruler units > Click on the arrow to display the measurement units > When you complete the adjustment, click OK to save.
The trick boss has finished sharing about the case where the Ruler bar in Excel is locked. Fixing this situation is super simple, right? Don't forget to refer to many other useful information from the admin!
Lesley MontoyaYou should read it
- How to use the Ruler ruler bar in Word
- How to display Ruler ruler bar in Micorosoft Word 2010, Word 2003, 2007, 2013 and Word 2016
- How to display the Ruler bar in Word versions
- How to Lock Cells in Excel
- Get familiar with Corel Draw - Lesson 2: Rulers, nets and lines
- The cause of Viettel sim is locked and unlocked
- How to turn Ruler on and off, ruler bar aligning margins in Word
- How to show the ruler in Word 2010 and the rule bar in Word 2010
May be interested
- How to show the ruler in Word 2010 and the rule bar in Word 2010
how to show the ruler in word 2010, the rule bar in word 2010. in the process of working with word 2010, you accidentally see the vertical ruler and the horizontal ruler, also known as the ruler bar. you are not sure how to display two ruler bars to c - How to create charts in excel 2007 is extremely simple!detailed instructions on how to create charts in excel 2007 are extremely simple for you to read
- Convert locked PDF files to Word, super simple methodconverting locked pdf files to word is a trick that many people are interested in. because in work, sometimes users encounter locked pdf files
- Find the hidden Ruler bar in Word very quicklythe ruler bar in word is hidden so you are wondering how to display this ruler bar again? learn how to show it again now!
- Instructions on how to open when Print title in Excel is lockedrest assured, if the print title feature in excel is locked, you just need to follow the instructions in tipsmake's article.
- Why should we use an electronic hydrometer to measure tilt?hydraulic ruler is a versatile measuring device used to measure tilt, angle, balance ... in many areas of life, production, construction and scientific research. let's find out why electronic tape measure is one of the most popular and most popular lines in nivo!
- How to Open Password-Protected Excel Filesthis article explains how to remove the password of a protected excel worksheet and how to crack the password of an encrypted excel file. in most cases, removing the password of a worksheet that is locked from editing in an excel file is quick and simple! however, if you need a password to open the file, the operation will be more complicated. there is no official way to decrypt excel files without using a password cracking program - often a resource-intensive process depending on the complexity of the password. you should still try it though!
- Adding 1 or more blank lines in Excel is extremely fastadding one or more blank lines in excel is a simple trick every excel user should know to be able to use this office software better. because of that, tipsmake.com we have written this tutorial for all interested readers.
- How to print two sides of paper in Word, Excel, PDF is extremely simplenot all printers support automatic duplexing of two-sided printing, so you need to know the extremely simple two-sided paper trick in word, excel and pdf.
- How to display the Ruler (alignment bar) in Wordto present the first work document and force you to align the text. in some cases the ruler is hidden so you don't know where to align.
Office information
- Opening a PowerPoint file with Repair error, how to handle it?
- How to insert PDF into Google Docs
- How to remove scanned document stains on Google Drive
- Quick method to fix Excel loop error
- Word has a letter spacing error and how to fix it
- Word has a Product Notice error and how to fix it in detail from A to Z
Opening a PowerPoint file with Repair error, how to handle it?
How to insert PDF into Google Docs
How to remove scanned document stains on Google Drive
Quick method to fix Excel loop error
Word has a letter spacing error and how to fix it
Word has a Product Notice error and how to fix it in detail from A to Z