What is REVIEW Tab in Microsoft Excel & It's Uses

In this article, we will learn What is REVIEW Tab in Microsoft Excel & It's Uses.

ReView Tab

Under this tab, Excel offers tools to check your document. Search some words in a dictionary, find synonyms or translate a word to verify the spelling.

REVIEW Tab 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.

Proofing
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.

Accessibility
Check Accessibility -Displays the Accessibility Checker Task Pane. This identifies any aspects of your workbook that could be altered to assist people with disabilities.

Insights
Smart Lookup -Displays the Smart Lookup Task Pane. This is powered by Bing and provides wiki articles and top related searches from the web.

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

Comments
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.

Notes
Notes - (Drop-Down). The drop-down contains the commands: New Note, Previous Note, Next Note, Show/Hide Note, Show All Notes and Convert to Comments.

Protect
Protect Sheet - Displays the "Protect Sheet" dialog box.
Protect Workbook - The drop-down displays the following commands: Protect Structure and Windows as well other Restrict Permission options. These can only be used if you have IRM [link] installed.

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.

Ink
Hide Ink - Drop-Down. The drop-down contains the commands: Hide Ink, Delete All Ink on Sheet and Delete All Ink on Workbook.

Changes
In newer versions this group is removed.

Protect and Share Workbook - Displays the "Protect Shared Workbook" dialog box.

Track Changes - Drop-Down. The drop-down contains the commands: Highlight Changes and Accept/Reject Changes.

Hope this article about What is REVIEW Tab in Microsoft Excel & Its use is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share them 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 to us at info@exceltip.com.

Useful Articles :

10+ Creative Advanced Excel Charts to Rock Your Dashboard : These creative charts can make you stand apart from the crowd. These charts can be used for different types of reports. Your dashboard will be more expressive than ever.

How to Save and Use an Excel Chart Template : It is important to save chart templates for repetitive charts to save time and energy. To save chart templates in excel follow these steps.

Best Charts in Excel and How To Use Them :  These are some of the best charts that Excel provides. You should know how to use these charts and how they are interpreted. The line, column and pie chart are some common and but effective charts that have been used since the inception of the charts in excel. But Excel has more charts to explore.

Excel Sparklines : The Tiny Charts in Cell : These small charts reside in the cells of Excel. They are new to excel and not much explored. There are three types of Excel Sparkline charts in Excel. These 3 have sub categories, let's explore them.

Change Chart Data as Per Selected Cell : To change data as we select different cells we use worksheet events of Excel VBA. We change the data source of the chart as we change the selection or the cell. Here's how you do it.

Popular Articles :

50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.

How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup a value from different ranges and sheets.

How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.

How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.

How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.