Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Subtotal function in Excel
  • Conditional Formatting Rules in Excel
  • Excel Bar Chart
  • How To Filter Data in Excel
  • How to Use Solver Tool in Excel

References

  • Find closest match in Excel
  • Two-column Lookup in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • How to get first row number in range in Excel
  • How to use Excel ROWS Function

Data Validations

  • Excel Data validation allow uppercase only
  • How To Create Drop-down List in Excel
  • Excel Data validation must contain specific text
  • Excel Data validation only dates between
  • Excel Data validation specific characters only

How to multiple users can work on a Workbooks at same time

by

If you share a workbook, you can work with other people on the same workbook at the same time. The workbook should be saved to a network location where other people can open it. You can keep track of the changes other people make and accept or reject those changes.

To share a workbook, execute the following steps.

1. Open a workbook.

2. On the Review tab, in the Changes group, click Share Workbook.

The Share Workbook dialog box appears.

3. On the Editing tab, click the check box and click OK.

Excel saves the workbook. You can now work with other people on the same workbook at the same time. The screen above shows you who has the workbook open.

Highlight Changes

You can highlight the changes on screen other users has made.

1. On the Review tab, in the Changes group, click Track Changes.

2. Click Highlight Changes.

The Highlight Changes dialog box appears.

3. Click OK.

Excel highlights the changes on screen.

Apparently, Aiden has changed the Sales of Smith from $16,753.00 to $26,753.00.

Accept/Reject Changes

You can now accept or reject this change.

1. On the Review tab, in the Changes group, click Track Changes.

2. Click Accept/Reject Changes.

3. Click OK.

4. Click Accept to accept the change or Reject to reject the change.


Note: not all features are available in a shared workbook.

Post navigation

Previous Post:

TRUE function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Pie Chart

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel OR Function
  • Return blank if in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • Not Equal To ‘<>‘ operator in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to enter Today’s Date or Static Date and Time in Excel
  • Get work hours between dates and times in Excel
  • Custom weekday abbreviation in Excel
  • How to calculate nth day of week in month in Excel
  • How to calculate Day of the Year in Excel

Grouping

  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • Categorize text with keywords in Excel
  • Group arbitrary text values in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to calculate percent change in Excel
  • Using Existing Templates in Excel
  • Zoom Worksheet in Excel
  • List sheet names with formula in Excel
  • Subtotal by color in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning