WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Print Comments in Excel

Print Comments in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

How to Print Comments in Excel?

To print comments in excel we need to go to the print section from the files tab and page set up tab where we will find any options to print comments and where we want to display them, whether on the end of the sheet or as they are present in the sheet.

Methods to Print Comments

There are two ways to print our handy comments in excel along with the report.

  1. Using an Excel page layout option.
  2. Using print preview method in Excel.

Again, there are a couple of options to print the comments. We can print the comment at the end of the page, or we can print the comment as displayed on the worksheet too.

You can download this Print Comments Excel Template here – Print Comments Excel Template

#1 Print Comments using Excel Page Layout Option

Assume you have the below report in your excel sheet and you want to print the comments using the page layout option.

If there are a lot of comments, it is better to print all the comments at the end of the sheet. Printing all the comments in excel after the rest of the data will eliminate the overlapping of the crucial cell comments when the details are displayed.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

We just need to do some settings tuning to get this done.

Print the comments at the end of the Excel sheet

  • Step 1: Your data should like this.

print comments in excel step 1

If you look at the cells from E2 to E8, it contains some comments in it. A little red mark indicating that the cells contain comments in it.

In order to print the comments at the end of the excel sheet first, comments should be appearing by default; otherwise, it will print the comments as is shown in the sheet.

  • Step 2: Now go to Page Layout, then Page Set up, and click on the little arrow mark.

print comments in excel step 2

  • Step 3: As soon as you click on the bottom right expand arrow, it will open up the below dialogue box.

print comments in excel step 3

  • Step 4: Now go to the Sheet tab and click on that tab.

print comments in excel step 4

  • Step 5: After clicking on the sheet tab, you need to select At the end of the sheet option under the Comments section.

print comments in excel step 5

  • Step 6: Once the “At the end of the sheet” option is selected, you need to click on the Print option.

page setup

  • Step 7: once the print option is selected, it will take you to the print preview section.

print preview

On the first page, it will print the report, and on the second page, it will print all the comments. And the final output will be as per the below image.

print comments in excel step 9

print comments in excel step 10

Print the Comments as Shown in the Active Window

In the last example, we have seen printing all the cell comments at the end of the sheet. Instead, we can print the comments referring or pointing to the cell itself. For this, we need to select the other option in Step 5.

page set up

After this, click on the print option, and it will open up the print preview dialogue box. Click on the print option to get the print, and the print will be as shown in the below image.

print comments in excel step 11

#2 Using Print Preview Method

In the last example, we have seen printing the comments using a page layout option. We can print the comments using the Print option too. Very similar to the last method but instead of going for Page Layout, select the Print option (Ctrl + P).

  • Step 1: Go to FILE and select the PRINT option.

go to file select print

  • Step 2: Once you click on that PRINT option, it will open up the below window and click on Page Setup.

print

  • Step 3: Now, this will open up the page, set up a dialogue box, and select the Sheet tab.

page setup - sheet tab

  • Step 4: After clicking on the sheet tab, you need to select At the end of the sheet option under the Comments section.

page setup

  • “At the end of sheet” option selected will print the comments at the end of the sheet.
  • “As displayed on sheet” will print as shown in the excel sheet.
  • None will print anything.

Recommended Articles

This has been a guide to Print Comments in excel. Here we discuss two ways -1) using the page layout option. 2. using print preview method along with examples and downloadable excel template. You may also look at these useful functions in excel –

  • Print Address Labels From Excel
  • How to Print in Excel?
  • Print Preview in Excel
  • How to Print Titles in Excel?
  • Scientific Notation in Excel
27 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Print Comments Excel Template

Coursera IPO Financial Model & Valuation Free Download