Printing Comment

amitk23

Board Regular
Joined
Nov 21, 2002
Messages
51
Hi,

Is there a way to print comments in Excel?

If yes please let me know.

Regards,

Amit
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

hsk

Well-known Member
Joined
Oct 19, 2006
Messages
567
Check excel help for "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.

How?

Click the border of the comment box so that handles (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) appear:


Do one or more of the following:
To move the comment, drag the border of the comment box.

To change the size, drag the handles on the sides and corners of the comment box.

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.
 

Forum statistics

Threads
1,181,362
Messages
5,929,535
Members
436,676
Latest member
Mavri

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