Excel is a powerful tool to enter all sorts of data. Sometimes, we need to add comments to our worksheets and print them. In this article, we will demonstrate how we can print worksheets with comments in Excel. After reading the methods, you will be able to print excel worksheets easily with comments.
Download Practice Book
Download the practice book.
How to Add Comments in Excel Worksheet?
Before printing comments, we need to know the process of inserting comments in an excel worksheet. Follow the steps below to know how you can insert a comment.
STEPS:
- Select a cell where you want to enter a comment. We have selected Cell D5 here.
- Now go to the REVIEW tab and select New Comment.
- Finally, type the comment you want to insert.
- Alternatively, you can use your mouse to insert comments. Select the cell and right–click the mouse and then, go to Insert Comment from the drop-down menu.
5 Easy Ways to Print with Comments in Excel
1. Print Comments at the End of Worksheet in Excel
Excel gives us the opportunity to print comments at the end of our worksheet easily. This method will help you to print all comments at the bottom of your worksheet. To explain this method, we will use a dataset of three columns. These are; Employee, Working Hour & Salary. This dataset also has two comments.
We will use the same dataset in all the methods.
Follow the steps to learn this method.
STEPS:
- At first, we need to display all the comments in our worksheet. We can see, there are two comments in our dataset. But, it does not display any comments.
- To display comments, go to the REVIEW tab and select ‘Show All Comments’.
- After that, all comments will be displayed like below.
- Next, go to the PAGE LAYOUT tab and select the Page Setup dialogue launcher.
- A Page Setup window will open. Go to Sheet and select ‘At end of sheet’. Click OK to proceed.
- Finally, if you see the Print Preview, you will see an image like below.
Read More: How to Find Comments in Excel (4 Easy Methods)
2. Print with Comments as Displayed in Excel Worksheet
In this method, the comments will be displayed in an excel worksheet. We will use the previous dataset here.
STEPS:
- Firstly, follow the steps of Method-1 to open the Page Setup.
- Secondly, select ‘As displayed on sheet’ from Comments.
- Now, select Print to print the worksheet.
- You can also see the preview form Print Preview.
- After selecting Print Preview, you will see the comments on your worksheet like below.
Read More: How to Print Sheet on One Page in Excel (9 Easy Ways)
3. Use of Print Preview to Print with Comments in Excel
We can also use the Print Preview feature to print our excel worksheets with comments. Observe the steps below to know more.
STEPS:
- In the beginning, press Ctrl + P from the keyboard. The Print options will occur.
- Now, go to Page Setup at the bottom of the window.
- Next, select Sheet from the Page Setup.
- After that, go to Comments and select the way you want to print the comments. We have selected the ‘As displayed on sheet’ option here.
- Finally, select Print to print the worksheet.
Read More: How to Display Print Preview with Excel VBA (3 Macros)
Similar Readings
- How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)
- Excel Button to Print Specific Sheets (With Easy Steps)
- Print Multiple Excel Sheets to Single PDF File with VBA (6 Criteria)
- Print Titles in Excel Is Disabled, How to Enable It?
- Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
4. Add Numbers in the Commented Cells before Printing
The comment indicators in our worksheets are not available when we print them. Sometimes, we need to use indicators in our printed sheets. Excel does not give any feature that can perform this task. However, we can use the VBA to print indicators.
Pay attention to the steps below for more.
STEPS:
- Firstly, go to the DEVELOPER tab and select Visual Basics.
- Secondly, go Insert in the Visual Basics window and select Module.
- Thirdly, type the code there and save it.
Sub Number_Indicator()
Dim wks As Worksheet
Dim cmnt As Comment
Dim lCmnt As Long
Dim rgCmnt As Range
Dim spCmnt As Shape
Dim spWd As Double
Dim spHt As Double
Set wks = ActiveSheet
spWd = 10
spHt = 9
lCmnt = 2
For Each cmnt In wks.Comments
Set rgCmnt = cmnt.Parent
With rgCmnt
Set spCmnt = wks.Shapes.AddShape(msoShapeRectangle,
_rgCmnt.Offset(0, 1).Left - spWd, .Top, spWd, spHt)
End With
With spCmnt
.Name = "CmtNum" & .Name
With .Fill
.ForeColor.SchemeColor = 9 'white
.Visible = msoTrue
.Solid
End With
With .Line
.Visible = msoTrue
.ForeColor.SchemeColor = 64 'automatic
.Weight = 0.25
End With
With .TextFrame
.Characters.Text = lCmnt
.Characters.Font.Size = 7
.Characters.Font.ColorIndex = xlAutomatic
.MarginLeft = 0#
.MarginRight = 0#
.MarginTop = 0#
.MarginBottom = 0#
.HorizontalAlignment = xlCenter
End With
.Top = .Top + 0.001
End With
lCmnt = lCmnt + 1
Next cmnt
End Sub
- Next, go to Macros of the DEVELOPER.
- Now, select Run from the Macro.
- Finally, you will see the indicators below.
Read More: How to Print Page Number in Excel (5 Easy Ways)
5. Use of VBA to Print Comments in Excel
VBA is a great feature of Microsoft Excel. It gives us the freedom to use excel in our way. We can use VBA to print any worksheet with comments very easily. We will use the previous dataset here. Our code will display the comments at first and then, print them.
Follow the steps below to learn this method.
STEPS:
- Initially, go to the DEVELOPER tab and select Visual Basics.
- Now, go to Insert in the Visual Basics window and select Module.
- After that, type the code.
Sub PrintComments()
Application.DisplayCommentIndicator=xlCommentAndIndicator
With ActiveSheet
.PageSetup.PrintComments = xlPrintInPlace
.PrintOut
End With
End Sub
- Then select Macros from the DEVELOPER.
- Next, select Run from the Macro.
- After selecting Run, the comments will be visible and it will start printing.
Related Content: VBA Code for Print Button in Excel (5 Examples)
Print Multiple Worksheets with Comments in Excel
We can print multiple worksheets with comments in excel. For that, we need to select multiple worksheets at first. To do that, press Ctrl from the keyboard and select the worksheets you want to print. Then follow Method-1 or Method-2 to print them.
Things To Remember
There are some important things we must remember before printing our worksheets.
- First and foremost, the comments must be set as visual before printing. This process is shown at the beginning of Method-1.
- The size of the comments should be small. It will help the readers to read the sheet easily.
- Excel will print the name of the user by default on whom the office is registered. You can change it when you start typing in the comment box.
Conclusion
There are many times when we need to print our excel worksheets with comments. We have discussed 5 easy ways here for printing comments. I hope, these methods help you to find the solution to your problem. Last of all, if you have any queries or suggestions, feel free to comment below.
Related Articles
- How to Remove Print Titles in Excel (3 Methods)
- How to Set Print Titles in Excel (2 Methods)
- Excel VBA: Print UserForm to Fit on a Page (2 Methods)
- Excel VBA: Print Range of Cells (5 Easy Methods)
- How to Print Gridlines with Empty Cells in Excel (2 Methods)
- How to Remove Pop-up Comments in Excel (4 Suitable Ways)