Question

write the steps to share the worksheet data

Answer 1

Steps to share the worksheet data

Explanation:

We can allow several users to work in the same Excel workbook simultaneously by saving the workbook as a shared workbook. Users will then be able to enter data, insert rows and columns, add and modify formulas and change formatting.

Follow these steps to create a shared workbook.

1. Click the Review tab.
2. Click Share Workbook in the Changes group.
3. In the Editing, tab clicks to select the Allow changes by more than one user at the same time. This also makes checkbox to combine the workbook, and then press OK.

Save the shared workbook on a network location in the Save As dialog box, where other users can access it.

Answer 2

Explanation:

follow me I will definitely give you follow back