ExcelBanter - How do I print, displaying comments on XL Spreadsheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I print, displaying comments on XL Spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/208019-how-do-i-print-displaying-comments-xl-spreadsheet.html)

Dawn Corbyn

How do I print, displaying comments on XL Spreadsheet?

I can view a spreadsheet, and choose to see the comments that I have entered.
I don't know how I can PRINT the same spreadsheet, displaying the comments,
as viewed on the screen.
Can anyone help me please?

Mike H

How do I print, displaying comments on XL Spreadsheet?

Hi,

File|Page Setup, Sheet Tab

From the dropdown select 'Comments as displayed on sheet'

Mike

"Dawn Corbyn" wrote:

I can view a spreadsheet, and choose to see the comments that I have entered.
I don't know how I can PRINT the same spreadsheet, displaying the comments,
as viewed on the screen.
Can anyone help me please?

All times are GMT +1. The time now is 09:15 PM.