MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I Still Use a Plus Sign for Entering Formulas


February 24, 2018 - by Bill Jelen

I Still Use a Plus Sign for Entering Formulas

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:

  1. Counting on your fingers the number of columns instead of highlighting the columns to see the count in the tooltip.
  2. Printing out two worksheets to compare them instead of using VLOOKUP
  3. Changing font color manually instead of using conditional formatting
  4. People who use =SUM(A1+5) instead of =A1+5
  5. 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.

continue reading »

More Reading


Calculation Bug When Changing VLOOKUP Table

Calculation Bug When Changing VLOOKUP Table »

February 23, 2018 - by Bill Jelen


There is an odd bug that can cause calculation errors in Excel when you make changes to the lookup table. Given that the Excel team's motto is "Recalc or Die", I am not sure why they won't patch this bug.

Double Click the Fill Handle to Copy a Formula

Double Click the Fill Handle to Copy a Formula »

February 22, 2018 - by Bill Jelen


My favorite Excel trick of all time: You have thousands of rows of data and have to copy the formula to the end. Don't try to drag the formula to the end. There is a better way.

read more news »

Featured Products


MrExcel XL =ROMAN(40)

MrExcel XL =ROMAN(40) »


Fun Excel book in full color. Includes Bill's favorite 40 Excel tips, plus Excel jokes, Excel Tweets, and Excel cocktails. Bonus section includes 40 keyboard shortcuts and more.

VBA & Macros for Microsoft Excel 2016

VBA & Macros for Microsoft Excel 2016 »


Use this guide to automate virtually any routine task: save yourself hours, days, maybe even weeks! Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful.

Guerrilla Data Analysis 2nd Edition

Guerrilla Data Analysis 2nd Edition »


This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and "MrExcel" himself, Bill Jelen.

Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Pivot Table Data Crunching: Microsoft Excel 2016

Pivot Table Data Crunching: Microsoft Excel 2016 »


Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.

More Excel Outside the Box

More Excel Outside the Box »


A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems.

see more products »