How to Add Floating Comment in Excel (3 Simple Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

floating comment in excel


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.

STEPS:

  • First, select cell D6.
  • Second, navigate to the Review tab.
  • Thirdly, click the New Comment icon.

Utilize Review Tab to Insert Floating Comment in Excel

  • 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.

Output of Utilizing Review Tab to Insert Floating Comment in Excel


1.2 Through Notes Group

Follow the directions below to finish the assignment with the help of the Notes group.

STEPS:

  • To begin, pick the B9 cell.
  • Secondly, go to the Review tab, followed by the Notes icon.

Utilize Review Tab to Insert Floating Comment in Excel

  • 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.

Output of Utilizing Review Tab to Insert Floating Comment in Excel

Read More: How to Insert Floating Table in Excel (2 Easy Ways)


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.

STEPS:

  • Firstly, right-click on cell B6.
  • Afterward, the Context Menu will open.
  • Later, choose New Comment.

Embed Floating Comment Through Context Menu

  • 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.

Output of Embedding Floating Comment Through Context Menu


2.2 From New Note Option

Follow these steps to finish the assignment using the New Note option.

STEPS:

  • To start, right-click on cell C7.
  • Afterward, the Context Menu will open.
  • Later, choose New Note.

Embed Floating Comment Through Context Menu

  • 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.

Output of Embedding Floating Comment Through Context Menu


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.

STEPS:

  • First, pick the active sheet of the workbook.
  • Second, navigate to Developer.
  • Then, click Visual Basic.

Add Floating Comment Through Excel VBA

  • 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.

Output of Adding Floating Comment Through Excel VBA

Read More: How to Create Floating Cells in Excel (2 Easy Methods)


Conclusion

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.


Related Articles

Lutfor Rahman Shimanto

Lutfor Rahman Shimanto

Hi there! I am Lutfor Rahman Shimanto. I have completed my graduation in Information Technology from Jahangirnagar University. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of work, I enjoy Chess a lot. I am a founding member of the Jahangirnagar University Chess Club and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo