to print inserted commments

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

To print inserted commments

resolvedResolved · Medium Priority · Version 2007

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?

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 tip:

How to apply the same formatting and data to multiple sheets at the same time in Excel 2010

When you want to format more than one sheet in a worksheet exactly the same way, Ctrl-click the tabs of the sheets you want to group together and they will all turn white. While they are grouped, anything you enter in one sheet gets entered into the others.

After you have done this, remember to click on the tabs to take them out of the group so that you do not accidentally insert data in multiple sheets when you just want to insert data in one.

View all Excel hints and tips


Server loaded in 0.08 secs.