Printing Comments

[ShearJohn]

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

 

[Von Pookie]

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,

 

[ShearJohn]

Kristy,

Many thanks for that, I'll try not to be so lazy in future

John

 

[Von Pookie]

I wouldn't feel too extremely bad about that. I had to look it up myself because I couldn't remember how