The subscribers of Office 365 may non honour it tardily to locate the buttons related to the ‘Shared Workbook’ feature inwards the Review tab of Microsoft Excel. The characteristic is deeply hidden together with non enabled yesteryear default. Microsoft claims it has removed together with thus since Excel offers ameliorate ways to part workbooks. Nevertheless, if yous desire to alter this together with add together Shared Workbook push clit to the Quick Access Toolbar inwards Excel, follow this post.
Add Shared Workbook buttons to Excel Quick Access Toolbar
The Quick Access Toolbar is the house where pocket-size buttons for taking quick actions reside. It tin hold upward establish next to the ‘Save’ selection inwards the top-left corner of the Excel window.
To begin, click the ‘File’ bill of fare together with select ‘Options’ from the listing displayed.
Next, select ‘Quick Access Toolbar’ from the left pane.
Now, expand the listing nether ‘Choose commands’ from together with select ‘All Commands’.
When done, scroll downward the listing to locate ‘Share Workbook (Legacy)’ item. When found, select it together with click Add.
Finally, click OK.
The newly added Share Workbook push clit volition straight off look at the overstep of the Excel window.
Like the above, yous tin follow the same physical care for to add
- Track Changes button
- Protect together with Share button
- Compare together with Merge Workbooks button
Please depository fiscal establishment annotation that yous may honour about articles showing these buttons visible nether the Review tab. However, later on next the steps above, these buttons volition hold upward added to the Quick Access Toolbar instead.
Also, brand certain yous desire to role these buttons earlier making whatsoever changes since it has many limitations. Most users recommend together with prefer using Co-Authoring characteristic over Shared Workbooks. It is an choice for Shared Workbooks.
If you’re using a version of Excel that supports co-authoring, cheque out our ship on how to co-author together with collaborate on Excel Workbooks at the same time.
Source: https://www.thewindowsclub.com/
comment 0 Comments
more_vert