Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to print reference label name in excel for comments?
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$? |
#2
|
|||
|
|||
Go to Print, Page Setup, Sheet, and select (under print), row and column
headings. This will print out the headings just as you see them on your monitor. HTH Carole O "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$? |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Excel file to PDF | Excel Discussion (Misc queries) | |||
I faxed an excel worksheet and now cannot print? | Excel Worksheet Functions | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Excel graph y axis label cut | Charts and Charting in Excel | |||
How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions |