Learn how to share your Excel Workbook across the web with others. You can do all the sharing via cloud apps like OneDrive right from within Excel.

If you would like to enable Shared Workbook option, here's a way to add it to Excel Quick Access Toolbar. It is hidden under Excel Options.

How to Make Excel Allow Multiple Users. When you store critical business information in an Excel worksheet, you may at times need to allow more than one person to edit the data simultaneously.

Microsoft Excel’s sheet view collaboration feature is not new, but now it supports hiding rows and columns and applying groups.

Click OK. Excel will open a new workbook with the copied sheet. If you’re using Excel 2007, do the following: Select the tab of the sheet you want to copy (or move).