Print comments at the end of your Excel worksheet

If notes in your Excel table are informative and their contents are clear even isolated from the commented cell, you can easily get them to paper at the end of the page. It’s also better to print cell notes below the rest of the data if they overlap important details when displayed. It’s doesn’t involve any copying and pasting, just follow the steps below:

1. In Excel go to the Page Layout tab and find the Page Setup section.
Go to the Page Layout tab and find the Page Setup section

2. Click on the bottom-right expand arrow icon to get the Page Setup window appear.
Click on the bottom-right expand arrow icon to get the Page Setup window

3. On the Page Setup window click on the Sheet tab, then click on the down arrow and select the optionAt end of sheet from the Comments drop-down list.
Select the At end of sheet option

4. Click the Print… button.
Press the Print… button

You’ll see the Print Preview page in Excel. If you scroll down, you’ll find the comments with their cell addresses ready for printing.
Use this option for the comments that contain complete information

Use this option for the comments that contain complete information you need to get visible on paper.

Excel – print comments as displayed

If your notes closely relate to the cell information, it may be ineffective to print them at the end of a sheet. In this case you can print comments in Excel 2010-2013 as displayed in your table.

1. Open your table in Excel, go to the Review tab and click on the Show All Comments option.
Go to the Review tab and click on the Show All Comments option

You’ll see your cell notes displayed.

See all cell notes displayed

Tip. On this step you can also change the way the comments are shown by drag-n-dropping to make sure that important details are visible and not overlapped.

2. Go to the Page Layout tab and click on the Print Titles icon.
Click on the Print Titles icon under the Page Layout tab in Excel

3. You will see the Page Setup window. Click on the small down arrow next to the Comments drop-down list and select the option As displayed on sheet.
Select the As displayed on sheet option

4. Press the Print button to preview the page. You will get the comments at a glance.
Preview the comments before printing

Now you know how to print comments in Excel 2010-2013 as displayed or at the bottom of the table. If you want to become a real comments guru and learn how to make the best of cell commenting, check out the post we published not so long time ago named How to insert comments in Excel, add pictures, show/hide comments.

That’s it! My comments have been successfully printed. Now I’m looking forward to your comments and questions. Be happy and excel in Excel!

Categories: កូនជាទីស្រលាញ់ | Leave a comment

Post navigation

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: