LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use programming to copy the comments, with the cell name, to a
different worksheet. There are instructions he

http://www.contextures.com/xlcomment...ml#CopyToSheet

There are instructions here for copying the code to your workbook:

http://www.contextures.com/xlvba01.html#Regular

To run a macro, choose ToolsMacroMacros
Select a macro, click Run

Needhelp wrote:
I have chosen to print comments at the bottom of my spreadsheet the problems
is it only gives the cell reference number. If I am looking at a printed
version I would not know what cell it is refering to. I then labeled
(reference) each cell but it still does not print out the name of the cell.
How can I print out the label name oppose to $b$3$?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

 
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
Print Excel file to PDF Rob Excel Discussion (Misc queries) 4 February 22nd 05 09:29 AM
I faxed an excel worksheet and now cannot print? C. P. Excel Worksheet Functions 2 February 21st 05 09:28 PM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 09:47 PM
Excel graph y axis label cut murreleteer Charts and Charting in Excel 2 January 9th 05 02:22 PM
How to print invoices for each advertiser from Excel worksheet Fred Excel Worksheet Functions 1 December 20th 04 09:08 AM


All times are GMT +1. The time now is 07:49 PM.

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

About Us

"It's about Microsoft Excel"