Under this tab,
Excel offers tools to check your document. Check spelling,
search some word in a dictionary, find synonyms or translate a word.
All these options
are offered under the group audit. You can
also share comments with other users of the document. The Comments group of commands allows you to manage comments
that you placed in the cells of the workbook. In the final group under this tab, you can manage who has access to the
workbook and the cells of the same workbook.
Proofing
One of the last elements to be completed
before a document is remmetre check the spelling. This can avoid you some errors that are easy
to correct.
Spellings
One of the last things to go before turning in a document is check spelling. This avoids errors that are easy
to correct.
Research
Excel allows you to look up a word or phrase through
multiple references. You can then
develop each resource to
provide you more information.
Select a cell and enter the password of your choice. Select the Review tab. Select Search.
The word will appear in the search box with a list of
items below.
To close this pane,
press the X button at the top right corner of it.
Thesaurus
Even in Excel, you may need to find synonyms for certain
words with the thesaurus.
Select a cell and enter the word amazing. Select the Review tab. Select Thesaurus.
A list of the synonyms appear in a box at the right of the
screen You can click on any word in
the list to continue your research. You can also begin a search on other words.
Translate
Select a cell and type a word or phrase of
your choice. Select the Review tab. Select Translation.
The word will appear in the
search box. You can change the language reference or the
desired result. You'll get a better result
by searching one word at a time that many at the same time.
Comments
You can put comments into
cells in Excel to remind you of important points or to convey information
or comments to other users of the workbook. This section will show you
how to add, browse, edit, view, print and remove comments.
New comment
Place the cursor in A1 cell. Press the New
Comment button. OR Press the right mouse button. From the context menu, select Insert Comment.
A yellow box will appear where you can add your
comments.
You can also change the size of this box to add more text.
Click outside the box when you
have finished writing your comment.
You will notice that there is now a red triangle in the upper
right corner of the cell. This is to indicate that there is a comment. Place the pointer
on the triangle to view the commentary.
Place a second comment
in cell D5.
You can
also move the comment when you write or edit. The advantage of this option is not to mask other important
numbers in your model.
Place the cursor on the border
of the comment box. While pressing the left button of the
mouse, move the box to a new location.
The comment will always
appear next to the cell unless you use the Show All
Comments. When cete option is used,
the comments are displayed at the point where you've moved.
Edit Comments
You can always change the
content of your comments.
Place the cursor in the cell where there are any comments you
wish to modify.
On the Review tab, the Add a comment turns into Edit
Comment.
Use this command
to modify the content of comments.
Delete
The comments you place on your spreadsheets
can be reminders or important changes. They are useless once you've made the
corrections to your model.
Place the
cursor in the cell where there is the comment to remove. Select the Review tab.
Press the Delete button .
Previous/ Next
With the Previous and Next buttons on the Review tab,
you can quickly switch to another comment.
Show/Hide Comment
You can view or hide the comments at any time by using this button.
Show All Comments
The Show all comments will help you focus on them
and see how they can improve your workbook.
Show Ink
Depending on the options available from the PC, Microsoft Office will also accept added notes from tablets or touchscreens. You can view these notes by pressing the Show Ink button.
Print the comments
It's also possible to print the
comments. This may
help explain the important points of your model. The following instructions explain how to print the comments of
your spreadsheets.
Select the Page Layout tab. Click the dialog launcher at the end the Page setup group of commands . Select the Sheet tab. From the Comments box, select either
At end of sheet or As displayed on sheet. Press OK.
Your next printing will
include comments either at the bottom of the page or where they are loated on your
worksheet.
Changes
The options in this group of commands allows you
to decide how other users have access to your document. You can
protect a worksheet or workbook in its entirety to ensure that no dispersion can
change your data or formulas. This protection applies to the entire sheet or workbook.
However,
you can enable them to modify certain data ranges. You can also share the workbook with other users and track
changes to the workbook.
Protect Sheet
Select the Review tab. Select Protect Sheet.
You do not have to put a password. It is optional. You can leave this box empty
while protecting your worksheet.
There are several options you can protect than just the
cells content. The list includes all the elements that you can
have a control to keep the presentation or allow certain options.
You can also enable the user to modify the content of
certain cells. For this you must select the cell range and press
the Allow Users to Edit Ranges.
To remove
protection, press the Unprotect Sheet. If you chose to include a a
password, you must enter it in the window before pressing the OK button.
Protect Workbook
You also have the option to protect the entire workbook instead
of protecting a worksheet.
Select the Review
tab. Press the Protect
Workbook.
You can
decide if you want to protect the structure or location of window if you have
multiple documents or views open at once.
To remove protection, press the button Unprotect workbook.
Share Workbook
Why use this option? It allows multiple users
simultaneously to enter or edit data in the same workbook! To
ensure that important data are not overwritten by users, the shared workbook
will keep track of changes in each cell. The worksheet "owner" will be able to review the
changes and decide which should be preserved or changed.
Excel 2007/2010
lets you share a workbook with multiple users. You must save the workbook to a network or shareble folder that is
accessible to other users. As a
result you have to share the workbook.
Some options are not
available in a shared workbook. For example,
options to insert rows, columns and worksheets will not be available.
Also, the majority of options
under the Insert tab (table, graphs, hyperlinks ...) will not be available.
The
document owner can withdraw at any time the sharing of the workbook. However, all changes by the other users before
will not be stored if the sharing is stopped before they saved their changes.
Protect and Share Workbook
The previous section showed how to share a workbook with
multiple users and limitations. This option mermet also share a workbook. However, it asks you to set a
password to ensure that only certain people have access to that file.
You will share the password to people who need access to the workbook.
Allow Users to Edit Ranges
Protection worksheets to ensure that no
modification is allowed unless you allow this option.
Select the range of cells you will allow users to modify the
content. Select the Review
tab. Press the Allow Users to Edit Ranges.
All cells in the workbook will be protected except those
that you allow the change.
In this way, a user can enter additional information without affecting the
template or the formulas that compose.
Track Changes
When sharing a document, you can ask to keep track of changes
in cells. You can then decide the
contents of a cell if several people get different information in a single
cell. The option to accept or reject
the change will allow you decide what information to keep or reject.
You like what you read?
Share it with your friends.
each resource to
provide you more information. 
Select a cell and enter the password of your choice. 
.
at the end the Page setup group of commands
.
