Spelling - (F7). Displays the "Spelling" dialog box. Allows you to check the spelling on the active worksheet.
Research - (Removed in 2016). Toggles the display of the Research Task Pane.
Thesaurus - Toggles the display of the Research task pane defaulting the research service to the thesaurus.
Check Accessibility - (Added in 2016). Displays the Accessibility Checker Task Pane. This identifies any aspects of your workbook that could be altered to assist people with disabilities.
Smart Lookup - (Added in 2016). Displays the Smart Lookup Task Pane. This is powered by Bing and provides wiki articles and top related searches from the web.
Translate - (Added in 2010). 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 - (Removed in 2019). Toggles the display of the comment in the active cell.
Show All Comments - (Removed in 2019). Toggles the display of comments in the active workbook (all worksheets).
Show Ink - (Removed in 2019). Show or hide ink in the active workbook. This is tablet specific.
Notes - (Added in 2019). Drop-Down. The drop-down contains the commands: New Note, Previous Note, Next Note, Show/Hide Note, Show All Notes and Convert to Comments.
In 2019 this group was removed.
Protect and Share Workbook - (Removed in 2019). Displays the "Protect Shared Workbook" dialog box.
Track Changes - (Removed in 2019). Drop-Down. The drop-down contains the commands: Highlight Changes and Accept/Reject Changes.
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 - (Removed in 2019) (Added in 2016). 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.
Hide Ink - Drop-Down. The drop-down contains the commands: Hide Ink, Delete All Ink on Sheet and Delete All Ink on Workbook.
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext