you may find yourself working on a
document and meeting other people's help
thankfully Excel includes two powerful
collaboration features comments and
co-authoring comments let you discuss a
particular section without altering its
contents while co-authoring allows
collaborators to view and edit your
document in real time for example I was
hoping a co-worker would help me edit
this schedule to get them involved first
I have to share the document by clicking
the share button in the top right corner
you'll have to upload your file to
onedrive before anyone can access it so
click on the onedrive option associated
with your account once the file is
uploaded you're ready to share it with
others first type in their email address
if Excel can't find their email in your
contacts list you may need to click an
empty part of the menu to close the
pop-up window next make sure this menu
gives them permission to edit the
document you can also include a brief
message if you like
once you're done click share and the
recipient can then access the file via
onedrive if you want to share with more
people simply repeat the process once
you're done click the X to close the
menu one great way to collaborate on
workbooks is the comments feature let's
say you want to delete feedback or ask a
question about this activity but you
didn't want to change the contents of
the cell you can do that by adding a
comment first click on the desired cell
then select the review tab click on new
comment
and start typing your message
when you're finished click anywhere
outside the box comments appear as a
little triangle in the corner of a cell
to read a comment just to move your
mouse over the cell if you want to edit
a comment select the desired cell and
click Edit comment now you can change it
however you like to keep a comment open
even when you aren't selecting it click
the desired cell then select show/hide
comment if you want to see all of the
comments simultaneously just click show
all comments click it again to hide them
getting rid of a comment is simple just
select the cell with a comment and click
delete another collaboration feature is
co-authoring which lets others view and
edit your document in real time being
able to quickly and easily edit a
document as a group can help make your
team's workflow more efficient keep in
mind however that real-time co-authoring
requires an office 365 subscription when
you co-author a document you can see
others at work each of them appearing as
a different color if you want to see
who's using a cursor just hover your
mouse over it and their name will pop up
I can see Tyrells cursor moving around
and editing content as he types it when
he or anyone else makes any change to
the document it's saved automatically
however if you're not happy with some
changes you can always go into the
version history and restore the document
to a previous state for example let's
say one of my co-authors didn't do such
a great job naming the activities to
reverse those changes click the clock
icon next to the share button
then double-click the version you want
back
once you determine that this is the
version you want click restore and it'll
become the current version these
collaboration features make it easy to
share ideas and feedback and hopefully
they'll make you and your co-workers
more productive
GCF global creating opportunities for a
better life