Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » To print inserted commments

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

To print inserted commments

Resolved · Medium Priority · Version 2007

Reply Tue 29 Nov 2011, 15:23Delegate Malika said...

Malika has attended:
Excel Advanced course

To print inserted commments

I would like to be able to print the comments in cells please how do i do that?

For upcoming training course dates see: Pricing & availability

Reply Wed 30 Nov 2011, 13:58Trainer Simon said...

RE: to print inserted commments

Hi Malika,

Thank you for your question and welcome to the forum.

The first thing you need to do is hsow all the comments on screen by using the Review tab and 'Show all Comments' option. Then go to the Page Setup options and select the Sheet tab.

In the Comments area, choose 'As displayed on the sheet" option.

I hope this answers your question.

Regards

Simon

Tue 6 Dec 2011: Automatically marked as resolved.

Excel articles

· Find Out Your Age In Days With Excel
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Create Contrasting Coloured Rows In Excel
· Make A Custom Sort List In Excel
· The Mysteries Of Excel Explained

Please browse our web site to find out more about
excel-training-advanced courses and other Microsoft training courses.

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips