Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing Comments
Does anyone know of a quick way to print comments in a cell besides going to Page Setup? I was hoping to convert them to it's own cell but didn't know if that was possible. -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=398761 |
#2
|
|||
|
|||
Coltsfan, couldn't you record a macro going to page setup sheet comments
as displayed on sheet, and assign it to a button on a tool bar? -- Sincerely, Michael Colvin "Coltsfan" wrote: Does anyone know of a quick way to print comments in a cell besides going to Page Setup? I was hoping to convert them to it's own cell but didn't know if that was possible. -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=398761 |
#3
|
|||
|
|||
You can print cell notes with your printed sheet by choosing cell notes
option on File, Setup, Sheets You can use a User Defined Function to get the comment value to be shown in another cell. http://www.mvps.org/dmcritchie/excel....htm#mycomment --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Coltsfan" wrote in message ... Does anyone know of a quick way to print comments in a cell besides going to Page Setup? I was hoping to convert them to it's own cell but didn't know if that was possible. -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=398761 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comments appear when printing | Excel Discussion (Misc queries) | |||
Comments Not Always Printing At End | Excel Worksheet Functions | |||
Printing hidden comments | Excel Discussion (Misc queries) | |||
Printing Comments in Excel 2003 | Excel Worksheet Functions | |||
printing spreadsheet comments | Setting up and Configuration of Excel |