how to make excel sheet shared in office 365

How to Make an Excel Sheet Shared in Office 365

Are you looking for a way to make an Excel sheet shared in Office 365? If so, this article will guide you through the process step by step.

To start, open your Excel workbook and select the sheet you want to share. Then, click on 'File' > 'Save' to save the workbook in its current location. Next, click on 'File' > 'Save As' to save it to a public folder. Note that if you want to make an existing workbook shared, simply open the workbook you want to share and follow these steps.

First, click on 'Review' > 'Share Workbook'. In the pop-up 'Share Workbook' dialog box, click on the 'Editing' tab and check the box beside 'Allow changes by more than one user at the same time'. This will enable multiple users to edit the workbook simultaneously. Then, click on 'Save' to save your changes.

Next, click on 'File' > 'Save As' to open the 'Save As' dialog box. Select a public folder to save your workbook and give it a name. Make sure that the public folder can be edited by all staff members.

If you previously used Shared Workbooks on a network drive, you can still access the Shared Workbook buttons if needed. Simply click on 'Review' > 'Share Workbook' to open the 'Share Workbook' dialog box and follow the same steps as before.

As a Human Resource Administrator for the PVA offices, I have worked extensively with Excel, Word, Office 365, Outlook, and KHRIS (the Payroll & Human Resource System of KY State Government). With my expertise, you can start making pivot tables, sharing Excel spreadsheets, editing XLS files, and more. Download Excel, buy Excel, or start a Microsoft Excel trial to get started.

When you open your shared workbook, you'll notice some changes in the appearance of your sheet. The column and row headers will have changed to a black background, and you'll see a 'Sheet View' section on the far left of the row.

With these simple steps, you can easily share an Excel sheet in Office 365 and collaborate with others in real-time. So why wait? Start making pivot tables, sharing Excel spreadsheets, editing XLS files, and more today!

How to make excel sheet shared in office 365