Hi, I was wondering if there was functionality in Excel that allowed me to
save basic formulas, that I use constantly in various worksheets, in a drop
down box or short cut avenue so that I don't have to retype them every time?
Some examples:
=text(a1,"mmddyyyy")
=abs(a1)

On Sep 25, 3:21*pm, jen wrote:
Hi, *I was wondering if there was functionality in Excel that allowed me to
save basic formulas, that I use constantly in various worksheets, in a drop
down box or short cut avenue so that I don't have to retype them every time? *
Some examples:
=text(a1,"mmddyyyy")
=abs(a1)

Add a named range to your personal file, ideally "formulas". Delete
the "=" sign.

When you need a particular formula. Call the range, Ctrl-C, reselect
the cell where it is desired, & ctrl-v
f2, home, "="

Works for me.