we're going to talk about some of the
things that you can do to finalize a
workbook it's a good idea to do these
things if you're going to be sending it
out or publishing it just like with any
document you should spellcheck your
workbooks even if you mostly just have
numbers you probably have headers or
other text that could have spelling
errors just go to the review tab and
then click spelling
if you've used Microsoft Word the
spellcheck works the same way and it
gives you several different options for
each misspelled word in this case the
spellcheck caught the word gab which is
the name of this company so that's not
actually a misspelling and I'm going to
add it to the dictionary so it won't
come up as an error again
now this is a misspelled word so I'll
select the word I want from the list of
suggestions and then click Change
if it asks you if you want to continue
checking at the beginning of the sheet
click yes
so it'll check the whole sheet
and here's another misspelling
and that's it
the next thing I'm going to do is
inspect this workbook this will tell me
whether there is hidden information that
I need to remove
click the file tab
and then go to check for issues
and inspect document
have unsaved changes in your workbook
you'll see this message and you can just
click yes to save it
you can just leave all of these boxes
checked and then click inspect
it looks like the document inspector did
find some information because there is
an exclamation point here now you don't
have to remove this information you can
just use the document inspector to see
what it finds but generally it's just
going to be things like the author's
name or the printer properties I'm going
to remove it because the people that I'm
sending this file to don't really need
to have this information
then you can close this window
the last thing I'm going to do is
protect this workbook go to protect
workbook
and you have several different options
some of them offers stronger protection
such as encrypt with password which is
good for really important or sensitive
workbooks but I don't need that much
security for this one so I'm going to
select mark as Final which will
discourage people from editing it and
also let them know that it's the final
version
and then click okay
and click okay again
now when somebody opens the file they'll
see this bar at the top of the window
and they won't be able to type or delete
anything
however if somebody needs to edit the
workbook they can just click Edit anyway
that means this isn't providing actual
security but it does keep people from
accidentally changing or deleting
something and if you need stronger
security you'll need to choose one of
the other options
so this workbook is finalized now and
I'm ready to send it out like what you
just saw rate it at a comment subscribe
to our Channel the freedom to learn what
you want when you want
absolutely free
GCF learn free.org