Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stanley
 
Posts: n/a
Default Display Comments on Each Page

I have a spreadsheet that I need to add comments to. Currently the method to
leave comments about a particular cell is to use a textbox or shape with text
in it. As you can imagine this can clutter the spreadsheet.

I know you can have the comments print at the bottom of the sheet, however,
I need the comments to print at the bottom of the sheet that that cell is
printed on. So if I have a 3 page printout the comments on page 1 should show
at the bottom of page 1 not on page 4 all by themselves. I also need the
comments or would like to have the comments handle carriage returns. I know
how to pull out the comments for a range however I have run into the issue of
formating them. Anyone have any examples or ideas that can help me? Thank you.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to display current page number in any cell of that page. Laljeet Excel Discussion (Misc queries) 8 February 2nd 08 01:31 AM
how do I display row 1 (my column titles) as I page down in excel John Schering Excel Worksheet Functions 2 December 1st 05 03:01 PM
Totaling Each Page Scott Excel Discussion (Misc queries) 0 June 17th 05 12:29 AM
excel 2003 page numbering art Excel Worksheet Functions 3 December 8th 04 10:49 PM
Combine & Display “Fixed” & “Automatically Updated” Date Parts texcel Excel Worksheet Functions 1 November 1st 04 05:38 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"