Microsoft Excel is, without a doubt, one of the most powerful computer programs available. By utilizing Excel’s tools and functions, we can carry out an infinite number of actions on a particular dataset. Adding floating comments in the appropriate cells of an Excel spreadsheet is a specific need for us. This post will explore several straightforward approaches to embedding floating comments in Excel. As a result, you must go through these 3 simple methods to add a Floating Comment in Excel.
Download Practice Workbook
You are welcome to get a free copy of the sample workbook we referred to throughout the presentation by clicking on the link immediately below.
3 Simple Methods to Add Floating Comment in Excel
For the sake of providing an example, let’s investigate a sample dataset. In the dataset that follows, for instance, four columns are labeled Product, Availability, Sales Rep, and Total Sales. We will demonstrate floating comments in various cells by utilizing all the 3 methods. In addition, I have yet to mention that to write this essay; I have been operating with the most recent version of Microsoft Excel 365. You can select any other edition that meets your requirements most suitably.
1. Utilize Review Tab to Insert Floating Comment in Excel
The Review tab is the traditional method for adding comments to Excel cells. Two options are available on the Review tab for adding comments to a specific cell. One is in the Notes group, the other in the Comments group.
1.1 From Comments Group
To complete the work with the assistance of the Comments group, adhere to the guidelines below.
- First, select cell D6.
- Second, navigate to the Review tab.
- Thirdly, click the New Comment icon.
- Subsequently, a tiny Comment Box will pop up.
- After that, write the desired notes or comments in the Input section.
- Later, hit the Post icon or press the Ctrl+Enter key.
- Finally, move the Mouse cursor to cell D6 to get the intended out.
1.2 Through Notes Group
Follow the directions below to finish the assignment with the help of the Notes group.
- To begin, pick the B9 cell.
- Secondly, go to the Review tab, followed by the Notes icon.
- Subsequently, a drop-down bar will open.
- After that, choose New Note.
- Due to this, a small Note Box will pop out to take input.
- Later, write your comment in the Box, then click on any other cell.
- Now, hover over the B9 cell to demonstrate desired output.
2. Embed Floating Comment Through Context Menu
The Context Menu is a panel that displays a graphical user interface in response to user input and a right-click mouse activity. A context menu presents limited options relevant to the operating system or application to which the menu belongs. The most efficient way to add floating comments in Excel is to use the Mouse cursor. Like before, there are two options to add comments to a cell. Here, we will call these the New Comment option and New Note option.
2.1 Through New Comment Option
Follow the instructions below to finish the assignment with the support of the New Comment option.
- Firstly, right-click on cell B6.
- Afterward, the Context Menu will open.
- Later, choose New Comment.
- Subsequently, a small Comment Box will open.
- Now, type the comments you want in the Input box.
- Next, press the Ctrl+Enter key or click the Post icon.
- Presently, hover over the B6 cell.
- Consequently, the intended output will display as follow.
2.2 From New Note Option
Follow these steps to finish the assignment using the New Note option.
- To start, right-click on cell C7.
- Afterward, the Context Menu will open.
- Later, choose New Note.
- Subsequently, a tiny Note Box will appear.
- Now, type any notes you prefer in the Box.
- Next, click on any other cell.
- At this point, move your mouse cursor over to the B6 cell.
- Thus, the intended output will display as follow.
3. Add Floating Comment Through Excel VBA
The acronym VBA stands for Visual Basic for Application. Microsoft created VBA as its programming language. Users can access Excel-incompatible functionalities by utilizing the VBA programming language. This section will use VBA to import Floating Comment into Excel. Note that we must open the desired sheet as the active sheet. Please follow the instructions below to complete the work correctly.
- First, pick the active sheet of the workbook.
- Second, navigate to Developer.
- Then, click Visual Basic.
- After that, select Insert, followed by Module.
- Next, enter the following code into the Module Box.
Sub addFloatingComment() Worksheets("Excel VBA").Cells(7, 4).addComment ("Well done, Amelia.") End Sub
- Significantly modify the Worksheet name, the Cell number, and the Comment you want to input.
- Later, press F5 or click the Run button to conclude.
- For this demonstration, hover over cell D7.
- As a consequence, the following will be the output.
From this point forward, you can add Floating Comment in Excel by following the methods we just covered. You may find many articles similar to this on the ExcelDemy Website. Continue utilizing them, and let us know if you have any additional ideas or other methods for finishing the assignment. Please send any queries, criticisms, or suggestions in the below space.