Excel Tutorial

Excel Tutorial Shortcut Keys in Excel Formatting in Excel Notes in Excel Formats in Excel Cells and Ranges in Excel Excel Function and Formulas Conditional Formatting in Excel Data Validation in Excel Charts in Excel Excel Ribbon Toolbar Basics of Excel Spell Check in Excel Data Analysis in Excel AutoFill in Excel Goal Seek in Excel Solver in Excel Pivots Table in Excel Go-To Special function in Excel Blank cells in Excel Count Cells with Text in Excel Date and Time in Excel-VBA Dependent Drop-down List in Excel Operators in Excel Dependent Combo box in Excel VBA Error Bar in Microsoft Excel Excel Axes Excel File using Password Excel Unique Values Frequency Distribution in Excel Gauge Chart in Excel Histogram in Excel Sum Every Nth Row in Microsoft Excel SumIF Formula in Microsoft Excel Multiplication in Excel Unique Values in Excel Trendline in Excel Excel Themes Copying formula in Excel Check Marks in Excel Calculating the Last Day of the Month in Excel Calculating Age in Excel Insert Row in Excel

Functions

Excel MAX() Function Excel INT() Function Excel MOD() Function Excel ROUND() Function Excel ROUNDUP() Function Excel AVERAGE() Function Excel COUNT() Function Excel COUNTA() Function Excel COUNTBLANK() Function Excel MIN() Function Excel EDATE() Function Excel EOMONTH() Function Excel HOUR() Function Excel MINUTE() Function Excel SECOND() Function Excel TIME() Function Excel WORKDAY() Function Excel WORKDAY.INTL() Function Excel DAYS() Function Excel WEEKNUM() Function Excel WEEKDAY() Function Excel SMALL() Function Excel LARGE() Function Excel LEFT() Function Excel RIGHT() Function Excel MID() Function Excel FIND() Function Excel SEARCH() Function Excel EXACT() Function Excel SUBSTITUTE() Function Excel TEXT() Function Excel VALUE() Function Excel AND() Function Excel OR() Function Excel IFERROR() Function Excel IF() Function Excel Nested IF’s Function Excel IFNA() Function Excel COUNTIFS() Function Excel VLOOKUP() Function Excel HLOOKUP() Function Excel INDEX() Function Excel MATCH() Function Excel OFFSET () Function Averageif Function in Excel

How To

How to import Microsoft Access data into the Microsoft Excel How to use TODAY function in Excel How to Alphabetize in Excel How to remove duplicate values from excel How to lock cells in Excel How to create drop down in excel How to Delete Row in Microsoft Excel How to Highlight Duplicates Words in the Microsoft Excel How to print titles in Excel How to make use of the Wildcard in Excel How to Make Use of the F-Test in Excel How to make use of the Excel Autofit in Excel How to generate random numbers in Excel How to apply Advanced Filter in Excel How to use Index and Match in Excel

Misc

Absolute Value in Excel Adding Column in Excel Converting Units in Excel Count Characters in Excel Custom Sort Order in Excel Decimals in Excel Division in Excel Locate Maximum Values in Excel Nearest Multiple in Excel Paste Options in Excel Quarter Dates in Excel Row Difference in Excel Separate Strings in Excel Reverse List in Excel Array Formula in Excel What if Analysis Data Table in Excel Excel Shortcut Keys What is a spreadsheet in Excel?

Notes in Excel

Notes in Excel

Notes are used to include additional information to the cell and explain formulas calculation, any modification made to the cell, providing necessary information on data that is entered or to provide any guidance on data that a user should enter. The information included in the Notes box helps users who are not the original owner of that workbook to get additional information about the cell.

Why are Notes useful?

  1. They are highly useful to get acquainted with the functions and formulas used in the cell for future reference.
  2. If something is highly important, and you don’t want to get it accidentally deleted, so notes are used to indicate the message.
  3. When a user wants to file specific data quickly over the worksheet, he/she can add a note to that cell.
  4. It aids users who are not the original owner of that workbook to get additional information about the cell.

Notes Shortcut for Windows

For Window Excel, use SHIFT + F2 keyboard shortcut to insert/edit the note in any cell

Notes Shortcut for Mac

For Mac Excel, use Fn+ ?+ F2 keyboard shortcut to insert a note in any cell

Insert a note in Excel

Follow the given below steps to insert a note in Excel:

  1. Select the cell at which you want to add your note.
Insert a note in Excel
  • Right click on the cell, and then click on the “New Note” option.
2.	Right click on the cell, and then click on the “New Note” option.
  • You will notice that a note dialog box has appeared on the right side of the selected cell. Type your note and click on the enter button.
You will notice that a note dialog box has appeared on the right side of the selected cell.
  • Excel displays a red triangle-shaped icon in the upper-right corner of the selected cell.  
Excel displays a red triangle-shaped icon in the upper-right corner of the selected cell.
  • Click outside the note box and then hover over the cell to view the note. Similarly, when someone will hovers this cell, the note will be reflected automatically.
Similarly, when someone will hovers this cell, the note will be reflected automatically.

Change the Note Username

Excel automatically adds the username to the top of the note box. But the user can alter the name.  Follow the below steps to change the name:

  1. Under the File tab, click Options. A dialog box appears, as shown below.
Under the File tab, click Options. A dialog box appears, as shown below.
  • You will find the “username” option under Personalize your copy of Microsoft Office category. Type the desired username and click on ok.
You will find the “username” option under Personalize your copy of Microsoft Office category. Type the desired username and click on ok.
  • You will notice that your note name has been changed.
You will notice that your note name has been changed.

Edit/ delete a note in Excel

To edit a note, execute the following given steps:

  1. Select the cell with the note which you want to edit.
Select the cell with the note which you want to edit.
  • Right click on the cell, and then click on the “Edit Note” option.
Right click on the cell, and then click on the “Edit Note” option.
  • Again the note box will appear and type the amended version and click on enter.
Again the note box will appear and type the amended version and click on enter.
  • You can delete the note on the cell by again right clicking on the cell and selecting the “Delete Note” option.
You can delete the note on the cell by again right clicking on the cell and selecting the “Delete Note” option.
  • The note will no longer be available for that specified cell.
The note will no longer be available for that specified cell.

Hide/unhide a Note

As an Excel feature, the notes are only visible when someone hovers over the cell that contains the note(default). To keep the notes visible all the time, execute the following steps.

  1. Select the cell that contains the note.
Select the cell that contains the note.
  •  Right on the selected cell, from the review tab, click on the “Show/Hide Note” option.
Right on the selected cell, from the review tab, click on the “ShowHide Note” option.
  • The note is now visible even if we are on another cell. This feature is used to highlight the note in Excel.
The note is now visible even if we are on another cell. This feature is used to highlight the note in Excel.
  • If you again right click on the cell containing the unhide note, and then select the “Hide/Show Note” option, the above property will disappear. And now the note will be only visible when you hover on the comment cell.