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

Data Analysis

  • Create Scatter Chart in Excel
  • How To Load Analysis ToolPak in Excel
  • How To Compare Two Lists in Excel
  • Excel Frequency Function Example
  • How to Create Area Chart in Excel

References

  • Count unique text values with criteria
  • Create hyperlink with VLOOKUP in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Count rows that contain specific values in Excel
  • How to get address of named range in Excel

Data Validations

  • Prevent invalid data entering in specific cells
  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation unique values only
  • Excel Data validation allow weekday 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:

SUMX2PY2 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

  • FALSE function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • Excel If, Nested If, And/Or Criteria Examples
  • Complete List of Excel Logical Functions, References and Examples
  • IFS function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • Convert Excel time to decimal minutes
  • Add days to date in Excel
  • Convert date string to date time in Excel
  • Sum race time splits in Excel

Grouping

  • If cell contains one of many things in Excel
  • Group arbitrary text values in Excel
  • Calculate conditional mode with criteria in Excel
  • Categorize text with keywords in Excel
  • Running count group by n size in Excel

General

  • Excel Ribbon Quick Overview For Beginners
  • AutoRecover file that was never saved in Excel
  • How to fill cell ranges with random number from fixed set of options in Excel
  • How to add sequential row numbers to a set of data in Excel
  • How to set or clear a print area in Excel Worksheet
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning