Hi Everyone
Here is the Twenty Fourth
Tip for you. Hope this help you.
How the COMMENT in the cell
will helps us.
If ever you want to insert
any review to a particular Text in a cell, you can do the same by inserting a
COMMENT to that cell.
How to Insert a COMMENT to
a cell.
1. Go to that cell, from
where you want to insert a COMMENT.
2. Go to REVIEW tab, and
select NEW COMMENT from there. Or use shortcut (Alt+R+C)
3. Now the cell will show
the comment.
How to Delete a COMMENT
from a cell.
1. Go to that cell, from
where you want to Delete the COMMENT.
2. Go to REVIEW tab, and
select DELETE COMMENT from there. Or use shortcut (Alt+R+D)
3. Now the cell doesn’t
contain any comment.
How to Show all COMMENTS in
a Worksheet.
1. Go to any cell in a
worksheet where you want to Show the COMMENT.
2. Go to REVIEW tab, and
select SHOW ALL COMMENT from there. Or use shortcut (Alt+R+A)
3. Now the sheet will show
all the comment.
Bonus Tip: You can also insert a
comment by clicking RIGHT CLICK from the Mouse on the particular cell and
choose option “INSERT COMMENT”.
Hope, this tip is clear
with my explanation.
In case of any doubt,
please feel free to contact me any time.
If any of your friends is
also interested for the said excel Tips, then asked them to fill the form by
clicking on the below mentioned link:
Please do share your
valuable feedback. Keep Sharing.
Thanks & Regards,
CA Mohit Bansal
Excel Enthusiast
+91-9045773456
No comments:
Post a Comment