Print Preview Comments in Excel 2007

[Dan]

Hello...

I have followed the procedures for being able to print 'comments' in Excel
2007 and have as yet been unable to do so. Can anyone print comments in Excel
or is it just our installation of Office Small Business that has the bug?

Scenario : Add a comment to a cell - check
Click view all comments -check
Print preview - check
Page Setup - check
Goto sheet tab - check
On the comments drop down the box is greyed out saying NO COMMENTS - when
clearly there are comments on the sheet.

What next chaps?

 

[Bob Buckland ?:-\)]

Hi Dan,

Is this a new workbook created in the release version of Excel 2007?

Try these steps on a new workbook.
1. Add data to the worksheet.

2. Select a cell with data in it, right click and choose
'Insert Comment'

3. Select a different cell, right click and choose 'Hide Comments'

4. On the Page Layout Tab use the 'Page Setup launcher'

5. On the review tab turn on 'Show All comments'

6. In the Page Setup dialog select the dropdown in the 'Comments' to 'as displayed in sheet' and click Print Preview.

The comments should appear in the preview if you've set a printer to use with Excel 2007.

==========
Hello...

I have followed the procedures for being able to print 'comments' in Excel
2007 and have as yet been unable to do so. Can anyone print comments in Excel
or is it just our installation of Office Small Business that has the bug?

Scenario : Add a comment to a cell - check
Click view all comments -check
Print preview - check
Page Setup - check
Goto sheet tab - check
On the comments drop down the box is greyed out saying NO COMMENTS - when
clearly there are comments on the sheet.

What next chaps? >>
--

Bob Buckland ?
MS Office System Products MVP

*Courtesy is not expensive and can pay big dividends*

 

[Dan]

Hi Bob,

Thanks very much that worked. I didn't notice the very small button on the
'page layout' tab. This brings up a drop down that 'isn't greyed out. But
when you goto print preview and bring up the same menu the ability to use
that drop down disapears and it becomes greyed out. This seems a little odd
as its the same menu as the one that is brought up using the 'page layout'
tab.

Our version is the full retail release of Office 2007 Small Business.

Thanks again