I Still Use a Plus Sign for Entering Formulas
February 24, 2018 - by Bill Jelen
I recently asked people for a list of the worst rookie Excel mistakes they've seen. I had to wince when one of those "rookie" mistakes is something I still to do this today: start a formula with =+.I cringed when the list of "worst rookie Excel mistakes" included something I still to do this day.
Here are some of the responses to my question:
- Counting on your fingers the number of columns instead of highlighting the columns to see the count in the tooltip.
- Printing out two worksheets to compare them instead of using VLOOKUP
- Changing font color manually instead of using conditional formatting
People who use
People who start formulas with
As I read through the responses, I was thinking, "Yes!, Yes!, Yes!, Yes!, Wait that's me!"
It is Excel Confession Saturday, but instead of changing my ways, I am actually going to try to defend them. The
=+A2 formula is faster to enter.