How to Add a Note in Excel

August 5, 2022
Views

A free Office suite fully compatible with Microsoft Office

Free Download

When you are working in Excel/Spreadsheet WPS, a lot of times it becomes necessary to add notes on different cells of the spreadsheet in order to share our opinion/comments regarding the data in the spreadsheet. These notes help us in communicating with others who have to review the data at later stage and therefore it becomes very important to add our notes/comments on the different cells in the Excel/Spreadsheet WPS. Most people are unaware that notes can be added in Excel/Spreadsheet WPS (2016/2019/Mac/Online) and most people do not know How To Add a Note in Excel/Spreadsheet (2016/2019/Mac/Online). There are a number of different ways to do it and the steps involved in doing it are easy-to-use by people of all age groups. Anyone can add a note in Excel/Spreadsheet WPS (2016/2019/Mac/Online) by using the following simple steps.

Using Excel/Spreadsheet WPS is simple and it is very helpful in performing a number of lengthy and difficult tasks. The steps below will help you understand How to add a Note in Excel/Spreadsheet WPS in just a few easy steps. After reading all the steps, you will be able to add a note in excel/spreadsheet WPS (2016/2019/Mac/Online) very easily.

Different Methods on How to Add a Note in Excel/Spreadsheet WPS

How to Add a Note in Excel/Spreadsheet WPS using Right-Click

Open the Spreadsheets in WPS Office.

   

 

2. Select the Blank to open a new sheet.

3. Find the cell on which you want to add a note and press the Right-Click on the mouse.

4. Click on the Insert Commentto add a note.

5. A note dialog box will open and you can add a note in it. After adding your note, click on any other cell and your note will be saved.

Note:The size of the note dialog box can be changed using the dots on its edges.

How to Add a Note in Excel/Spreadsheet WPS using Keyboard Shortcut

1. Select the cell to add a note and press the Shift and F2buttons together. The note dialog box will open and you can add a note in it. After adding your note, click on any other cell and your note will be saved.

How to Edit a Note in Excel/Spreadsheet WPS using Right-Click

1. Move the mouse cursor on the cell whose note you want to edit and press the Right-Click on the mouse.

2. Click on the Edit Comment to make changes to the note.

How to Edit a Note in Excel/Spreadsheet WPS using Keyboard Shortcut

1. Select the cell whose note is to be edited and press the Shift and F2buttons together. This will allow you to edit the note.

How to Delete a Note in Excel/Spreadsheet WPS

1. Move the mouse cursor to the cell whose note you want to delete and press the Right-Click on the mouse.

2. Select Delete Commentand the note of that cell will be deleted from the Excel/Spreadsheet WPS.

How to Show/Hide a Note in Excel/Spreadsheet WPS

1. Move the mouse cursor to the cell whose note you want to keep showing constantly and press the Right-Click on the mouse.

2. Click on the Show/Hide Comment.

3. Similarly, if you want to hide the already showing note, again Right-Click on the cell and click on Show/Hide Comment. Now, your comment will show only when the mouse cursor is moved to the cell on which the note was added.

This article has covered the methods on How to add a note in excel/spreadsheet WPS (2016/2019/Mac/Online), how to edit a note in excel/spreadsheet WPS (2016/2019/Mac/Online), how to delete a note in excel/spreadsheet WPS (2016/2019/Mac/Online) and how to show/hide a note in excel/spreadsheet WPS (2016/2019/Mac/Online). You can use these simple steps as explained above and easily add a note in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Hopefully, you have learned How to add a note in WPS Excel/Spreasheet (2016/2019/Mac/Online) by following the above steps .  If you want to know more about Word features, you can follow WPS Academy to learn. You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.

Was this helpful?