If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formulas
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) |
#2
|
|||
|
|||
Formulas
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. |
Thread Tools | |
Display Modes | |
|
|