Note: by default, Excel customizes the Quick Access Toolbar for all documents. Under Customize Quick Access Toolbar, select the current saved workbook to only customize the Quick Access Toolbar for this workbook. For example, take a look at the quick access toolbar with the Form command in this Excel file: data-form.xlsx. ![]() Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac If you're using the latest version of Excel and you're an Office 365 subscriber, you may find that buttons related to the 'Shared Workbook' feature are no longer on the Review tab. We've removed them because there's a much easier and better way to share workbooks, and that's with. You can still access the Shared Workbook buttons if you need them. For example, you may need to turn off the Shared Workbook feature, or you may be in the middle of using the feature. The quickest way to get these buttons back is to add them to your Quick Access Toolbar. The Quick Access Toolbar is the bar of small buttons at the top of the Excel window, to the right of the Save button. Add Shared Workbook buttons to the Quick Access Toolbar • Click File > Options > Quick Access Toolbar. ![]() • Open the list under Choose commands from and select All Commands. • Scroll down that list until you see Share Workbook (Legacy). Select that item and click Add. • Then scroll through the list until you see Track Changes (Legacy). Select that item and click Add. • Scroll through the list until you see Protect Sharing (Legacy). Remote control desktop for mac. Select that item and click Add. • Scroll through the list until you see Compare and Merge Workbooks. Select that item and click Add. • Now four new buttons will appear at the top of the Excel window. Each button looks like this: • Share Workbook button: • Track Changes button: • Protect and Share button: • Compare and Merge Workbooks button: You may encounter other articles that refer to these buttons being on the Review tab. But after doing the steps above, the buttons are available on the Quick Access Toolbar instead.
0 Comments
Leave a Reply. |