Abrar-ur-Rahman Niloy
Some report issues about cells not being highlighted after selection in Excel spreadsheets. This can happen for many different reasons ranging from minor issues like protected sheets to maybe settings in your operating systems. It can happen because sometimes the cells face issues while selecting, and sometimes the selected cells are not displaying correctly because of some issues. This article will focus on all possible fixes for selected cells not getting highlighted in Excel.
8 Possible Solutions If Selected Cells Are Not Highlighted in Excel
We will focus on a total of eight possible fixes for the problem of cells not getting highlighted while they are selected in Microsoft Excel. Each one has its own sub-section describing the process. Try each of them out to find the one that works for you.
Solution 1: Unprotect Your Sheet
One of the major reasons the cells are not highlighted while selected in Excel spreadsheets is that the sheets are protected. Depending on how one had protected the spreadsheet, it may be sometimes impossible to select any cell at all.
To find out the protection status of a spreadsheet, go to the spreadsheet. Then go to the Review tab on your ribbon. Under the Protect group, you will find the Protect Sheet/ Unprotect Sheet option.
If the option is Unprotect Sheet like we can see in the figure, then the spreadsheet is in protected status. Click on it to unprotect and you should be able to select and highlight the cells of your spreadsheet again if this was causing the issue.
If the problem still persists then try out the other solutions.
Solution 2: Don’t Uncheck ‘Select Locked Cells’ Option
Sometimes a user can prevent other users from selecting locked cells. This may end up causing selected Excel cells not to get highlighted for users of the other end. This will happen when someone unchecks the option Select locked cells while protecting the sheet. If you do that and protect the sheet, you won’t be able to highlight or select the cells of that spreadsheet.
Follow these steps to protect the sheet while preventing the problem.
Steps:
- First of all, go to the Review tab on your ribbon.
- Then select Protect Sheet from the Protect group.
- After that, make sure to check the Select locked cells option under the Allow all users of this worksheet to section.
- Finally, click on OK.
Henceforth, you should be able to select and highlight cells in that spreadsheet.
Read More: Excel VBA to Protect Sheet but Allow to Select Locked Cells (2 Examples)
Solution 3: Unlock Cells from Format Cells Dialog Box
Another cause for this problem is the Locked cells option in the formatting option of the cell/ range of cells. Try disabling it from the range. This may sometimes clear the problem and the cells get highlighted again if selected in the Excel spreadsheet.
Follow these steps to do that.
Steps:
- First of all, select the cell/ range of cells that are not getting highlighted while selected in the Excel spreadsheet. (If you are in doubt, select the whole spreadsheet.)
- Then press Ctrl+1 on your keyboard to open the Format Cells
- Now go to the Protection tab of the box and uncheck the Locked
- After that, click on OK.
- Now go back to the Review tab to select Protect Sheet from the Protect
- Then you can uncheck the Select locked cells option under the Allow all users of this worksheet to
- Finally, click on OK.
This will now enable the selected cells to be highlighted again in protected Excel spreadsheets.
Read More: Select All Cells with Data in Excel (5 Easy Methods)
Solution 4: Check Issues with Add-ins
Excel add-ins are wonderful additions to Microsoft Excel which help us to interact with Excel objects, extend functionality, add custom functions, and many more. In general, this helps with making the experience easier for us. But in some cases, this may be counterproductive.
Follow these steps to disable the add-ins.
Steps:
- First of all, you need to run Excel in safe mode. To do that, open the Run dialog box, and press the Win+R key on your keyboard.
- Then write Excel /safe in the field and click on OK.
- The Excel will now open up in safe mode. Now go to the File tab on your ribbon.
- Then select Options from the left side of the backstage view.
- After that, select the Add-ins tab in the Excel Options
- Then on the right side, select the COM Add-ins option beside the Manage box and click on Go.
- Next, uncheck all of the add-ins in the COM Add-ins box and click on OK.
This should resolve your problem if any of the add-ins were causing the issue.
Read More: [Solved!] CTRL+END Shortcut Key Goes Too Far in Excel (6 Fixes)
Similar Readings
- How to Go to Last Non Empty Cell in Column in Excel
- Select Data in Excel for Graph (5 Quick Ways)
- How to Select Only Filtered Cells in Excel Formula (5 Quick Ways)
- Select Visible Cells in Excel (5 Quick Tricks)
- How Do I Quickly Select Thousands of Rows in Excel (2 Ways)
Solution 5: Make Your Excel Folder Blank from C Drive
Sometimes some junk files may cause some errors in Excel’s functionalities which may end up not highlighting selected cells in Excel. If that is the case for you, try clearing up these files and then selecting the ranges again to check the difference.
To do that, go into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (Replace User_Name with your user name) with the file explorer and see if there are any new files there. Back up those files someplace else and delete them from this location.
Now try running Excel again to see if your problem is still there or not. If the process didn’t resolve it, try other solutions.
Solution 6: Repair Microsoft Office
If your problem still persists after trying all of these solutions, then try repairing the Microsoft Office to see if that makes any difference. Follow these steps to repair Microsoft Office in windows.
Steps:
- First of all, go to Settings by clicking on the windows icon on the bottom-left of your screen.
- Then select Apps.
- After that, select Apps & Features from the left side of the window.
- Now scroll down on the left and find Microsoft 365 or the one you are using.
- Then select Modify under it.
- Now select Quick Repair or Online Repair depending on the one you prefer.
- Finally, click on Repair.
This will repair Microsoft Office applications. If some undetectable changes were causing the problem, it may resolve the issue in some cases.
Solution 7: Restart Your PC
If none of the solutions above worked for you, try the good old-fashioned restart of your system. Restarting the system wipes away the current state of the software. If any bugs or codes cause such problems restarting wipes them away and the OS comes to start everything from the scratch. So it may remove some issues like some runtime errors or other forms of background apps that were causing the problem.
Conclusion
These were all the possible fixes if your selected cells are not getting highlighted in Excel. Hopefully, one of the above solutions worked out for you. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below.
For more guides like this, visit Exceldemy.com.
Related Articles
- How to Select Column to End of Data in Excel (3 Easy Methods)
- Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)
- How to Select Multiple Cells in Excel without Mouse (9 Easy Methods)
- Select Cells with Certain Value in Excel (5 Methods)
- How to Select a Range of Cells in Excel Formula (4 Methods)
- How to Select a Range of Cells in Excel (9 Methods)
