There are two main ways to share and collaborate on Excel workbooks with others, depending on whether you're using the Excel desktop application or Excel for the web:

Using Excel Desktop Application:

1. Save your workbook to OneDrive: OneDrive is a cloud storage service from Microsoft that integrates seamlessly with Excel. It allows you to store your workbook online and access it from any device.

2. Share the workbook: Here's how to share from OneDrive:
- Upload your workbook to OneDrive if it's not already saved there.
- Right-click on the file and select "Share."
- Enter the email addresses of the people you want to share with.
- Set permission levels: You can choose whether people can edit the workbook (default) or just view it.
- Add a message (optional).
- Click "Send."

Using Excel for the web:

1. Open your workbook in OneDrive: You can upload your workbook to OneDrive or open an existing one stored there.

2. Share the workbook: Here's how to share from within Excel for the web:

- Click the "Share" button in the top-right corner.
- Invite people by entering their email addresses and setting permissions (edit or view).
- Add a message (optional).
- Click "Send."

Collaboration Features:

Once you've shared your workbook, here are some key collaboration features:

- Real-time co-authoring: Multiple people can work on the same workbook simultaneously and see each other's changes in real-time. This is best experienced in Excel for the web.
- Version control: Excel keeps track of changes made by different users, allowing you to revert to previous versions if needed.
- Cell highlighting: Cells being edited by others are highlighted with different colors, helping avoid conflicts.

Additional Tips:

Discuss edits beforehand: If multiple people are working on complex formulas or data, it's helpful to discuss edits beforehand to avoid confusion or overwritten changes.

Use comments: Use the "Comments" feature to leave notes and questions for other collaborators within specific cells.

By following these steps and leveraging the collaboration features, you can effectively share and work together on Excel workbooks with others.