Review Tab in Microsoft Excel

Review tab contains the editing feature, comments, track changes and workbook protection options. These features make it easy to share the data with the proper information whilst ensuring security of data.

 

image 1

Review tab contains 4 groups:-

 

image 2

 

a)    Proofing: -We use proofing to correct the typo mistakes through spelling option. Research and dictionary work alike. And Thesaurus suggests other ways to say anything.

image 3

 

b)    Language: - We use this optionto translate the sentence in any other language.

image 4

 

c)    Comment: -When we want to give the message about the cell, we use comment option. We can insert and delete the comment, show and hide the comment, and then we have an option to show all the comments.

image 5

 

d)    Changes: - We use Changes option to protect the sheet and workbook, and we can allow user to edit the specific range; also, we can share the workbook as well. When we want to prevent the unwanted changes in the sheet by others, we can protect the sheet by using the “Protect Sheet” option. And, if we don’t want other users to do any structural changes in the workbook such as moving, deleting or adding sheets, we can do it by using the “Protect workbook” option. Using “Share workbook” option, we can grant access to multiple users to work on a file at the same time. We use “Protect and share workbook” option to share the workbook and protect change tracking with a password. We use “Allow users to edit ranges” to set up password protection on few ranges and we can select the users who can edit those ranges. We use “Track changes” to keep the track of changes made in the file.

image 6

 

Previous
next

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube