Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding default comment text
Does anyone know if there is a way to add default text to a comment so
whenever I insert a comment that text is there? For example, if I have a financial spreadsheet and every comment I add looks like this: Current Month: $##.## Adjustments: $##.## Can I make a default comment with the current month and adjustments field pre-loaded so whenever I insert comment all I have to do is fill in the dollar amount. Thanks much, Dan |
#2
|
|||
|
|||
I am wondering why you don't want to put this in columns on the worksheet? Is
there no chance you will ever need to use the data in calculations? That's much less hassle. The columns can be hidden if you don't want to print them. On Fri, 8 Apr 2005 08:05:03 -0700, "dshigley" wrote: Does anyone know if there is a way to add default text to a comment so whenever I insert a comment that text is there? For example, if I have a financial spreadsheet and every comment I add looks like this: Current Month: $##.## Adjustments: $##.## Can I make a default comment with the current month and adjustments field pre-loaded so whenever I insert comment all I have to do is fill in the dollar amount. Thanks much, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
Adding two text cells together | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
How do I set default comment font | Excel Discussion (Misc queries) | |||
how do i set default font / text size in comments? | Setting up and Configuration of Excel |