To remove other track changes, such as formatting, ink, insertions and deletions and markup area highlight, uncheck the appropriate options from the drop-down menu. From the drop-down menu, Uncheck Comments. And now, you just can see the formatting tracked changes, then, go on clicking Review > Accept > Accept All Changes Shown as following screenshot shown:ģ. Locate and click the Show Markup pane in the Track Changes section. In the track changes mode file, click Review > Show Markup, and then uncheck the Comments and Insertions and Deletions options, and leave the Formatting option checked, see screenshot:Ģ. In Word document, you can also apply the Show Markup function to finish this job, please do with following steps:ġ. And then press F5 key to run this code, and only the formatting track changes have been accepted in the active Word document immediately. If Left(xRev.FormatDescription, 10) = "Formatted:" Thenģ. VBA code: Accept format track changes only in Word document Sub AcceptFormatChanges()įor Each xRev In ActiveDocument.Revisions And then, click Insert > Module, copy and paste below code into the opened blank module: Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. The following VBA code can help you to accept the formatting track changes only in Word document, please do as this:ġ.
#How to mass accept all formatting changes in word how to
This article will talk about how to solve this task in Word document.Īccept only formatting track changes in Word with VBA codeĪccept only formatting track changes in Word with Show Markup function But, sometimes, you just want to accept the formatting track changes without accepting the insertions or deletions. If you have a Word document which is in track changes mode, when you apply the Accept All Changes feature, all the track changes will be accepted.
For example, a dollar amount of 1,234.00 in an Excel worksheet used as a data source may display as 1234 in a Word document. How to accept format track changes only in Word document? However, you may notice a glitch that happens when you create a mail merge in Microsoft Word with Excel data, that is, the number formatting in Excel doesn’t show up correctly in the Word document.