Excel 2010 Review Tab Lesson-8

 Excel 2010 Review Tab Lesson-8

Review Tab:- Review in Excel has been divided into four Groups namely:- PROOFING Spelling Research Thesaurus Language All comment Changes Protect sheet Protect workbook Shared Workbook Protect & Share Track Changes COMMENTS New comment Delete Previous next Show/hide comment

Spelling - (F7). Displays the "Spelling" dialog box. Allows you to check the spelling on the active worksheet.

Research - Toggles the display of the Research Task Pane.

Thesaurus - Toggles the display of the Research task pane defaulting the research service to the thesaurus.

Translate - Toggles the display of the Research task pane defaulting the research service to the translation.

New Comment / Edit Comment - (Shift + F2). Inserts a comment at the active cell.

Delete - Deletes the selected comment.

Previous Comment - Moves to the previous comment in the active workbook.

Next Comment - Moves to the next comment in the active workbook.

Show Comments - Toggles the display of the Comments task pane

Show/Hide Comment - Toggles the display of the comment in the active cell.

Show All Comments - Toggles the display of comments in the active workbook (all worksheets).

Show Ink - Show or hide ink in the active workbook. This is tablet specific.

Protect Sheet – When you protect a worksheet, Excel locks all of the cells from editing. Protecting your worksheet means that no one can edit, reformat, or delete the content. Click on the “Review” tab on the main Excel ribbon. Click “Protect Sheet.” Enter the password you would like to use to unlock the sheet in the future

Protect Workbook -To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password. ... To lock your file so that other users can't open it, see Protect an Excel file.

Allow Edit Ranges - Allows specific users to edit certain ranges in a workbook or sheet. Before using this option you need to define your security settings using the Protect Sheet command. This command is disabled when the worksheet is protected.

Unshare Workbook - This is disabled by default. If you open a workbook that is currently being shared using the legacy "Share Workbook" feature this button will become enabled, allowing you to unshare the workbook. Shared workbooks have been replaced with Co-Authoring. Press the 'Share' button in the top right corner to display the Share Task Pane. Workbooks must be saved to an online location.

Share Workbook - Allows multiple users to work in a workbook at the same time. The workbook should be saved to a shared drive. Workbooks containing tables cannot be shared. Displays the "Share Workbook" dialog box.

Track Change :-Put a check mark in the box beside Track Changes While Editing, Then, you can select when, who, and where at in the worksheet that you want to track changes.

Now, when you or anyone else makes changes or edits this excel sheet, these changes will be noted by assigning a color by MS Excel 2010. For example, John changes may show as a cell highlighted in red, Sara in blue, etc. These are assigned by default. You cannot assign colors to users.

When you click on the triangle in the upper left hand corner of the cell, the user’s initials will appear. This is another way to let you know who made what changes.

Accepting or Rejecting Changes:

Whenever you or someone else makes a change to the excel worksheet using Track Changes, you can then decide whether to accept or reject the change.To do this, go to the Review tab, click Track Changes, then select Accept/Reject Changes. This dialogue box will appear:

You can select when the changes were made that you want to accept or reject, who’s changes, and where at in the worksheet that you want to review changes. Click OK when you’ve selected which changes. A new dialogue box will appear:

It shows who made the change, what change was made, then gives you the option to accept the change, reject it, accept all changes made in the worksheet, or reject all of them.