[Music]
there may be some times when you're
collaborating on a project and you might
have a co-worker or a friend make
changes to your workbook for example
here I'm working on a schedule for a
company retreat and I'll need a couple
of my co-workers to fill in some of the
blanks and possibly make corrections I'm
going to use two features that will
really make this a lot easier track
changes and comments and these are both
found on the review tab
first go to track changes and click
highlight changes
put a checkmark where it says track
changes while editing
and here you can customize which changes
are highlighted but I want to highlight
all of them so I'll just leave these as
they are
make sure highlight changes on-screen is
checked and click OK
an excel needs to save the workbook now
so just click OK to save it
and I'll pretend that I'm a co-worker
who's making changes to this workbook I
see a couple of items in the schedule
that need to be changed
and when I do that the cells will get
this little triangle in the corner and
also a border
and if somebody else makes changes then
they'll show up as a different color
when you hover over the cell you'll be
able to see exactly what was changed and
also who made the change
this workbook now has
different tracks changes and I think it
would be easier to read them if they
were listed on a separate sheet to do
this you'll first need to save your
workbook
and then go to track changes and click
highlight changes
checklist changes on a new sheet
now when you first turn on track changes
you might not be able to select this so
if that happens you'll need to click OK
and then come back to this window and
then you should be able to select it
and it will create a new sheet called
history
and now it can just glance over all of
the different changes that were made and
I can also see which cells they're in
right now the changes that we've made
our sort of temporary and we'll need to
either accept the changes to make them
permanent or reject them so go to track
changes and accept reject changes
I want to look at all of the changes
that have not been reviewed so I'll just
leave this checked and you could also
narrow it down by reviewer or to a
specific range of cells
and then click okay
you'll be able to review each change and
you can choose to accept or reject it
but I know that I want to keep all of
these changes so I'll accept all
another great reviewing feature that you
can use is comments let's say I want to
make a suggestion or ask a question
without actually changing the cell I'll
just add a comment to the cell by first
clicking on it and then selecting new
comment
in comments will show up as a little
triangle in the top right corner of the
cell
you'll be able to read them whenever you
hover the mouse over the cell
but I'd like to view all of them at once
so I'll click show all comments
you can edit a comment by clicking here
I'm just going to add a sentence to
clarify this question
I'm finished with this schedule now so
I'll delete all of the comments by
selecting each one and clicking the
delete command
and I'll also turn off
act changes just go back to highlight
changes
and then uncheck this box
once you do this any tract changes that
you haven't reviewed will automatically
be accepted so just make sure that you
really want to do this and then click
yes
track changes and comments are great
features to use when you're
collaborating on a project and you don't
necessarily have to be on a company
network to take advantage of these
features you can still collaborate over
email or you could even just have all of
the collaborators edit the workbook on
the same computer like what you just saw
rate it at a comment subscribe to our
chill the freedom to learn
what you want when you want absolutely
free GCF learn free.org