Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table-is it possible to enter comments that "move" with Piv
is it possible to enter comments / notes in to a pivot table so that
they"move" as you open and close sections (excel2007), and stay with the information you are commenting on? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table-is it possible to enter comments that "move" with Piv
Hi,
No. However, in 2007 there are built-in information tips for every cell in the pivot table and these adjust as you change the pivot table. Having said No, above, if the comment was designed to say something that related to the row and column fields you could create a vba code that rewrote the comments everytime you refreshed. For example suppose you wanted the comment for a cell that was in a column field titled month to display the month name, or indicate the row item, you could do that. -- Thanks, Shane Devenshire "gaj" wrote: is it possible to enter comments / notes in to a pivot table so that they"move" as you open and close sections (excel2007), and stay with the information you are commenting on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When i press "ENTER", it move rightward, (i want it to go down!) | Excel Discussion (Misc queries) | |||
how to change "move selection after enter" in office 2007 | Excel Discussion (Misc queries) | |||
Click "Enter" move to cell to the right, not down in Excel | Excel Worksheet Functions | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Use look-up table in Excel and enter into a "county" column, same | Excel Worksheet Functions |