![merge and center in excel is grayed out merge and center in excel is grayed out](https://cdn.ablebits.com/_img-blog/fill-empty-cells/select-range.png)
- #Merge and center in excel is grayed out how to#
- #Merge and center in excel is grayed out password#
- #Merge and center in excel is grayed out download#
Until you save changes the limes appear greyed out. In the bottom section of Highlight Changes screen, there is a box labeled with “ List changes on a new sheet”. Here is the most important of the Track Changes. Tap the OK option and then decide what changes you want to reject or which you want to accept. Here you have to fill up the When, Who and Where choices. This will open the dialog box of select changes to accept or reject. For this, you need to make a click on the Tools> Track Changes> Accept and Reject Changes. So when you place the pointer over that cell, the following showing screen will pops-up.Īt any moment, you can accept, reject, or review the changes. Now all changes will be easily tracked.Īfter making changes in the cell, Track Changes records it and posts it with a small black triangle sign in the cell upper left corner. Tap the Continue button, and your workbook will get into the Shared mode. It will also give you the option Continue or Cancel. Suppose, in case you want to monitor the complete worksheet then left uncheck the Where option.īut to monitor only a specific section of your worksheet fill the Where option and check that section too.Īfter customizing the options when you tap to the OK button, Excel asks you to Save the Workbook. Before putting any option from your side explore the default option first. Place a checkmark across “ Track changes while editing” option.Īfter that click on the down arrow present next to When, Who, and Where. You can see that the option under the command will appear dimmed in color. To turn on the disabled track changes option open a worksheet and follow these options: Tools> Track Changes > Highlight Changes.
#Merge and center in excel is grayed out how to#
How To Fix Excel Track Changes Grayed Out Issue? 1# Remove The Shared ModeĪs we all already discussed that Excel track changes grayed out also when the workbook is in shared mode.
#Merge and center in excel is grayed out download#
Download Excel File Repair Tool rated Excellent by Softpedia, Softonic & CNET.
#Merge and center in excel is grayed out password#
But if in case you want to prevent users from doing such changes then apply the password before sharing the workbook. Users can also make remove or modify the tracked changes. Thus any changes done before turning on this Excel tracking option will not be tracked. Among these features, the Excel track changes option is also the one that becomes unavailable.Īnother reason can be that your Excel Track Changes option is disabled. When a workbook is shared, most of Excel’s editing feature gets unavailable. The very first reason behind the Excel Track Changes option not working is the sharing of the workbook.
![merge and center in excel is grayed out merge and center in excel is grayed out](https://i.stack.imgur.com/DsP5t.png)
Source: Why Excel Track Changes Option Grayed Out ?
![merge and center in excel is grayed out merge and center in excel is grayed out](https://dummytech.com/wp-content/uploads/2018/02/Screenshot_2018-02-20-17-39-47-768x1365.png)
So there is something in this sheet which is causing track changes to be grayed out. This workbook contains 5 worksheets, so I tried moving (copying) each sheet to a new workbook, and I found that when I copy one particular sheet, track changes option gets grayed out in the new workbook. I tried searching, but couldn’t find any solution. However track changes button is grayed out. I have an excel workbook (.xlsx) in which I want to track changes.