Printing Comments

ShearJohn

New Member
Joined
Sep 8, 2002
Messages
16
Can anyone tell me if its possible to print an excel spreadsheet including any comments that are showing? It doesnt seem to want to do it for me.

Many thanks
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
From the Excel help file:

Print comments
Click the worksheet.

If you want to print the comments in place on the worksheet, display the comments you want to print.

To display an individual comment, right-click its cell and then click Show Comment on the shortcut menu. To display all comments, click Comments on the View menu. Move and resize any overlapping comments as necessary.

On the File menu, click Page Setup, and then click the Sheet tab.

Do one of the following:
To print the comments where they appear on the worksheet, click As displayed on sheet in the Comments box.

To print the comments at the end of the sheet, click At end of sheet in the Comments box.

Click Print.

Hope it helps,
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
I wouldn't feel too extremely bad about that. I had to look it up myself because I couldn't remember how :LOL:
 

Forum statistics

Threads
1,144,737
Messages
5,726,000
Members
422,652
Latest member
Elnene1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top