MS Excel Course > Protecting sheets

Sharing Workbook in MS Excel

387k
Overview

How do I share an Excel Spreadsheet in Google Drive

Now we will see that how can we share an Excel spreadsheet in Google drive.

For this we will use an option which is present in our REVIEW tab, i.e. Share Workbook.

When we click that we will see an option of sharing workbook with others, we need to checkbox that option true, now our workbook will be shared with any other person according to our preference who can make changes inside this spreadsheet.

Now again if we go to share workbook option, we can see another column for advanced options, which has track changes option, update changes option, controlling changes between users option etc...

Here we can select any option according to our requirement and then can share this workbook with any of our colleagues or users working on this file.

See More

"Shared Workbooks" is an older feature that allows numerous individuals to collaborate on a workbook. This function has a lot of drawbacks, thus it's been phased out in favour of co-authoring.

The benefits of sharing workbook in MS Excel are:

  • Sharing data with other people
  • Making it easier to collaborate on projects
  • Copying formulas from one workbook to another

Sharing a workbook with others is as easy as 1-2-3!

  • Create a workbook in Excel and save it to your computer.
  • Open the File tab and select Share Workbook.
  • Choose the option you want, such as "Allow editing" or "Do not allow editing".

There are many advantages of using MS Excel for sharing workbooks. One advantage is that it is easy to share and collaborate with others on projects. Another advantage is that you can make changes to your workbook and update it in real time without having to worry about saving it or losing any data.

The requirements for the computer that is used to share the workbook are:

  • Laptop or desktop with Windows 7 or higher
  • Microsoft Excel 2010 or newer
  • Microsoft Word 2010 or newer

Learner's Ratings

4.4

Overall Rating

  • 68%
  • 20%
  • 6%
  • 3%
  • 3%

Reviews

A
Aqib aziz
5

I LIKE THIS COURSE VERY MUCH AND I AM FROM PAKISTAN

V
Vanshika aggrwal
5

Good

S
Shreya Maitreyee
5

best platform to learn everything free...i have learned ms excel course ...

K
kushagra kumar
5

best

K
Komal Wankhede
5

NICE COURSE FOR FREELANCING WORK

A
aarju magar
4

effective course

M
MOHD ABDAL
5

NICE COURSE

I
Ishitta kotwal
4

should be more precise btw it's an amazing course

N
Nida Naaz
4

Great Learning but please ask the questions in Quiz that we study ,please do not ask that Questions which is not study.

A
Abhishek Gihar
5

Great Learning Experience.

Show More
Recommended Courses
Course Content

  1. Menu in Excel
    4m 57s
  2. How to use LearnVern
    3m 20s
  3. Quick Access Toolbar
    6m 21s
  4. Formula Bar in Excel
    2m 5s
  5. Status Bar in MS Excel
    5m 23s
  6. Navigation in MS Excel
    3m 4s
  7. Shortcuts in MS Excel
    4m 15s
  8. Format Painter in MS Excel
    2m 29s

  1. Data Entry in MS Excel
    5m 9s
  2. Autofill in MS Excel
    5m 42s
  3. Data Entry for Date-Time in MS Excel
    5m 46s
  4. Undo-Redo in MS Excel
    5m 32s
  5. Comments in MS Excel
    4m 1s
  6. Saving File in MS Excel
    4m 27s

  1. Creating Formula in MS Excel
    7m 45s
  2. Copy Formula in Excel
    3m 35s
  3. Till Date Formula in MS Excel
    3m 36s
  4. Pct Calculation in MS Excel
    5m 20s
  5. Absolute in MS Excel
    6m 10s
  6. Sum Average in MS Excel
    6m 5s
  7. Other Common Functions In MS Excel
    7m 52s

  1. Formatting Fonts in MS Excel
    3m 49s
  2. Adjusting Rows & Columns in MS Excel
    4m 2s
  3. Alignment in MS Excel
    7m 10s
  4. Formatting Borders in MS Excel
    2m 55s
  5. Formatting Numbers in MS Excel
    7m 23s
  6. Formatting Date-Time in MS Excel
    10m 47s
  7. Conditional Formating in MS Excel
    10m 38s
  8. Formatting Tables in MS Excel
    8m 43s
  9. Formatting Shapes in MS Excel
    7m 5s

  1. Resizing Row & Column in MS Excel
    7m 18s
  2. Hide-Unhide Row and Column in MS Excel
    5m 29s
  3. Copy, Move, Insert Data in MS Excel
    5m 37s
  4. Find Replace in MS Excel
    6m 35s

  1. Printing in MS Excel
    6m 35s
  2. Page Break Preview in MS Excel
    5m 20s
  3. Page Setup in MS Excel
    4m 58s

  1. Creating Charts in MS Excel
    7m 13s
  2. Types of Chart in MS Excel
    5m 40s
  3. Formatting Charts in MS Excel
    6m 36s
  4. Chart Elements in MS Excel
    7m 44s
  5. Sparklines in MS Excel
    8m 1s

  1. Freezing Workbook in MS Excel
    7m 28s
  2. Splitting Sheets in MS Excel
    6m 39s
  3. Outline in MS Excel
    7m 3s

  1. Manage Multiple Workbook in MS Excel
    6m 48s
  2. Working with Sheets in MS Excel
    4m 42s
  3. Copy & Delete Sheets in MS Excel
    6m 36s
  4. Use of Formula in Worksheet
    9m 22s
  5. Edit Links in MS Excel
    10m 43s

  1. If Condition in MS Excel
    6m 26s
  2. VLOOKUP in MS Excel
    6m 2s
  3. VLOOKUP Exact in MS Excel
    4m 10s
  4. COUNTIF in MS Excel
    4m 25s

  1. Protecting Sheets in MS Excel
    4m 55s
  2. Securing Workbook in MS Excel
    5m 45s
  3. Password to Workbook in MS Excel
    2m 21s
  4. Sharing Workbook in MS Excel
    3m 10s
  5. Track Changes in MS Excel
    5m 33s

  1. Sorting in MS Excel
    6m 38s
  2. Subtotals in MS Excel
    7m 26s
  3. Filter in MS Excel
    5m 32s
  4. Split Data in MS Excel
    4m 21s
  5. Flash Fill in MS Excel
    3m 41s
  6. Remove Duplicate in MS Excel
    2m 33s
  7. Data Validation in MS Excel
    6m 50s

  1. Creating Pivot Table in MS Excel
    11m 11s
  2. Manipulating Pivot Table in MS Excel
    8m 29s
  3. Adding Slicers in MS Excel
    4m 36s
  4. Other Grouping of Pivot Table in MS Excel
    4m 40s

  1. Macro in MS Excel
    7m 29s

  1. Excel Assignment Q-1
    1m 11s
  2. Excel Assignment Q-2
    21s
  3. Excel Assignment Q-3
    34s
  4. Excel Assignment Q-4
    51s
  5. Excel Assignment Q-5
    48s
  6. Excel Assignment Q-6
    37s
  7. Excel Assignment Q-7
    47s
  8. Excel Assignment Q-8
    45s
  9. Excel Assignment Q-9
    37s
  10. Excel Assignment Q-10
    33s
Enroll For Free