- Microsoft Excel Spreadsheet
- Microsoft Excel Workbook
- Excel Workbook Download
- Free Microsoft Office Workbooks
How to create/make a shared workbook in Excel?
- A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch. Open an Existing Workbook. To open a workbook you've created in the past, execute the following steps. On the File tab, click Open. Recent shows you a list of your recently used workbooks.
- A workbook is an Excel file. It usually has a file extension of.XLSX (if you’re using an older version of Excel, it could be.XLS). A spreadsheet is a single sheet inside a workbook. There can be many sheets inside of a workbook, and they’re accessed via the tabs at the bottom of the screen.
Maybe sometimes you want to make a shared workbook for all the staff can edit and change the contents together, so now I introduce the steps about how to make such a shared workbook in Excel for you.
Hi I have Microsoft 365. When I right click on the Excel button on the taskbar at the bottom, to select which workbook I want to open. A ‘personal workbook’ always opens separately as well. How can I switch this off, and open the sheet I have selected only. I don’t have this problem on my works.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Create and make a shared workbook
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
1. In Microsoft Office 2010/2013, click File > New and select the workbook type you need to create a new workbook. (Click Office button > New to create a new workbook in Office 2007.)
2. Click Review > Share Workbook to open the Share Workbook dialog. See screenshot:
3. In the pop-up Share Workbook dialog, click Editing tab and check the box on which beside Allow changes by more than one user at the same time. This also allows workbook merging. Then click OK to close the dialog. See screenshot:
4. Then click File > Save As to open the Save As dialog, and select a public folder to save it. (Tip: You may sure that the public folder can be edited by all the staff.) Then click Save to save the workbook.
Note: If you want to make an exist workbook shared, just open the workbook you want to share, click Review > Share Workbook, In the pop-up Share Workbook dialog, click Editing tab and check the box on which beside Allow changes by more than one user at the same time. This also allows workbook merging. Then click OK. Then click File > Save to save the workbook in its current location, then click File > Save As to save it to a public folder.
Microsoft Excel Spreadsheet
Microsoft Excel Workbook
Relative articles:
Excel Workbook Download
or post as a guest, but your post won't be published automatically.
Free Microsoft Office Workbooks
Loading comment... The comment will be refreshed after 00:00.