Am wondering how to print comments (shift & f2 on cells) i've added to an excel 2007 pivot table and set to "show all comments".
They don't show in print preview, and "page setup > sheet" has a comments dropdown that is greyed out so can't be used.
Can anyone help advise? Google isn't much help when search terms include the word "comments".
Is the sheet/workbook protected?
Also, I seem to remember there's something funky about how you get to the page setup option. I think you need to go directly to it rather than print preview--> page setup. I had a similar trouble with paper sizes.
Page Layout > Page Setup allowed the dropdown for comments printing, cheers.
@aggi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Am wondering how to print comments (shift & f2 on cells) i've added to an excel 2007 pivot table and set to "show all comments".
They don't show in print preview, and "page setup > sheet" has a comments dropdown that is greyed out so can't be used.
Can anyone help advise? Google isn't much help when search terms include the word "comments".