Mastering Excel Worksheet Annotation In 5 Steps
Prevent yourself from getting overwhelmed when working with large amounts of data everyday by learning to keep track of your data with Excel worksheet annotation. Not only will it be beneficial for you, it can also benefit your co-workers who are working on the same project with you. Here’s how you can use Excel worksheet annotation:
1. Adding annotations
When it comes to creating excel worksheet annotation points, you can add them by choosing the cell you want to add the annotations to and searching for your Review tab. Select the Comments group and choose New comment from the options. This will successfully create a new comment, which will be annotated in red. Once you hover your cursor over it, your message will be revealed. You can change the default annotation names with your own by selecting the name in the comment and retyping it or removing it. Then simply type your message in and click on the outside to indicate that you have finished it.
2. Editing
To make changes to your Excel worksheet annotations, you can do so by selecting the cell of the comment you wish to edit. Go under the review tab of your document and choose Comments. This should make the Edit comment options available for selection. Double click the text of your annotation to enable editing and then choose the comment text box so that you can edit the text.
3. Format
The default text in excel worksheet annotations make use of the Tahoma font (Size: 8). While the default font is unchangeable, users can still choose to change the format of the annotation text for each comment as well as the shape. Select the cell containing the comment and choose the review tab once more. Locate the edit comment option from under the comments group, select the annotation text and right click. This will enable you to choose the format comment option, which in turn brings up the dialog box for it. You will then be able to choose from the available formatting options there.
4. Move/Resize
In order to move or resize the annotations, click on the cell containing the comments and choose Show/Hide comments. This will draw up a comment box border with sizing handles., You can then manually resize it by dragging the handles for according to the border sizing or move the comments based on the border.
5. Display/Hide
Excel worksheet annotations can be displayed or hidden along with their indicators with the changing of default settings for display. Choose Excel and select options. Locate the advanced category found under display and choose different display options from there.
This is what you have to know for Excel worksheet annotations. With the right amount of practice, you will be able to get accustomed to and effectively place the feature to good use in no time!