10 Common Spreadsheet Mistakes You’re Probably Making

10 Common Spreadsheet Mistakes You’re Probably Making

Spreadsheets are a stable in the business world. If you work anywhere in money, finances, business, or anything similar to those then you likely use a spreadsheet. They’re even used in the military to keep track of supplies. With so many people in so many industries using spreadsheets, you would imagine that people make a lot of errors. Correct! Here are ten common spreadsheet mistakes that you’ve probably made before.

common spreadsheet mistakes

    1. Mistakes in spreadsheet logic

    Spreadsheets are notoriously strict with things like order of operations. If you don’t type your equations and formulas in properly, you will get the wrong math which can wreck an entire spreadsheet. Thankfully there is something you can do about that and it’s simply a matter of using more parenthesis. Put parts of your equations in them in order to get the desired effect.

    common spreadsheet mistakes

      2. Misuse of built-in functions

      A single wrong letter in a function can change its entire meaning. For instance, AVERAGE will ignore all text and false entries. AVERAGEA converts all text and false entries to zero. That one letter can totally change the outlook and values in your spreadsheet. Companies have misused functions and had wrong values in their spreadsheets for years and it caused damage of millions of dollars. If you’re using a function, then double check to make sure you’re using the right ones.


      common spreadsheet mistakes

        3. Not copying all the cells you need

        When you work with spreadsheets, there can be a lot of copying and pasting. It’s a very common problem that people don’t select all the cells they need to copy and paste into the next workbook. If you don’t, you’ll have missing information. That can cause a lot of problems if it isn’t caught. Since spreadsheets can get ridiculously big, this is actually harder than it sounds. If you have 15 years of financial history and you only copy ten years of it, you may not catch that right away.

        common spreadsheet mistakes

          4. Keep your data entry and formula cells separate

          Formula cells and data entry cells should never be anywhere near each other. The reason for this is relatively simple. If you put values in the formula cells that are supposed to be in the data entry cells and vice versa, then you can seriously mess up your books. When you keep them separate, you run little risk of mixing the two up and that keeps your books and your bosses happy.


          common spreadsheet mistakes

            5. Save only when you need to

            This one seems odd but it’s true. You should only save when you need to. This bit of advice flies right in the face of the oft-told advice to save frequently. Here’s why you should only save when necessary. Assuming you hadn’t made a mistake up to the point when you opened a saved spreadsheet, you went through the project with a spreadsheet without a mistake. If you make a mistake and save it for a bunch of times, then your mistake gets saved and you won’t be able to recover your flawless copy later. Thus you should only save when you know what you just did was correct.

            common spreadsheet mistakes

              6. Create new spreadsheets if you want to experiment

              If you want to play around with your spreadsheets, you should make a copy and alter that instead. You should never tinker with your main spreadsheets because you could lose your original copy in the event that you accidentally saved. To avoid what could be a cataclysmic mistake, do yourself a favor and keep copies.

              common spreadsheet mistakes

                7. Give new cells a range name

                Range names can help you keep things organized. You can sort by range name and it helps you find information more quickly. It only makes sense that if you create new cells that you should give them a range name. Not giving new cells a range name can limit how they’re sorted and searched which can make them hard to find. You’d be surprised how many people add new cells to a huge spreadsheet and don’t give them range names. It makes things cluttered and more difficult to work with.


                common spreadsheet mistakes

                  8. Delete range names when you delete all of its cells

                  You should also delete range names when you delete all of its cells and it’s for exactly the same reasons as number seven. When you make major changes to your spreadsheet, you need to update everything around the change in order to ensure proper documentation. Not doing so can cause others to re-enter information that was supposed to be deleted and can also hinder things like searching and sorting.

                  common spreadsheet mistakes

                    9. Check your math

                    This seems like an obvious mistake but it’s absolutely essential. A company named Fidelity once had their books messed up by $2.6 billion over a silly minus sign. You can imagine what effect this had with investors and with the company’s higher ups. One tired night and you tap the minus sign on accident and you can make your company look like it has gained $1.3 billion more than it actually earned. Make sure you check even the most basic arithmetic you perform.


                    common spreadsheet mistakes

                      10. Have someone double check your work

                      Most of the largest mistakes made in the world of spreadsheets came from people not double checking their work. This mistake is then transferred up the chain of command without anyone else seriously checking everyone else’s work, and it can result in horrible problems. If you work with spreadsheets, then you should find someone to check yours every now and again to make sure the numbers add up. If you’re in charge of people who work on spreadsheets, then you should double check their work more often. An article from 2013 posits that 88% of spreadsheets have an error in them. That’s not a promising number.

                      At the end of the day it comes down to just paying attention. When your eyes stare at tiny numbers in tiny blocks all day long, they’re bound to start missing things. Make sure you take a step away from the computer every now and then and give your eyes and your brain a break. Spreadsheets are great but they’re also very tedious and it’s very easy to make a mistake if you’re not paying attention.

                      Featured photo credit: Sunoray via

                      More by this author

                      Joseph Hindy

                      A writer, editor, and YouTuber who likes to share about technology and lifestyle tips.

                      12 Inspirational Speeches That Teach You the Most Valuable Life Lessons 10 Benefits of Sleeping Naked You Probably Didn’t Know 15 Most Effective Cool Down Exercises For Every Workout 10 Things Guys Love That You Didn’t Expect 20 Google Search Tips to Use Google More Efficiently

                      Trending in Technology

                      1 How to Type Faster: 12 Typing Tips and Techniques 2 11 Meeting Scheduler Apps to Boost Your Productivity This Year 3 11 Google Chrome Apps & Features for Getting More Done with Less Effort 4 11 Brain Training Apps to Train Your Mind and Improve Memory 5 15 Productivity Chrome Extensions To Boost Productivity in 2020

                      Read Next


                      Last Updated on March 25, 2020

                      How to Type Faster: 12 Typing Tips and Techniques

                      How to Type Faster: 12 Typing Tips and Techniques

                      Typing is a lot of fun, especially if you’re the type of person who loves to write. Whenever an idea comes to your head or you just want to communicate something, the feeling of scribbling things down in a computer is awesome.

                      Do you know that being able to type faster makes you more productive? In fact, it’ll save you 21 days every year just by typing faster!

                      Many people look up to master typists and wish that to handle a keyboard like they do. The truth is that none of them started that way, and they had to learn.

                      In this piece, you’ll learn how to type faster with some useful tips and techniques:

                      1. Work on Your Workspace and Typing Area

                      A lot of people believe that fast and correct typing will start when you can master the keyboard. But the truth is, you will need to begin with getting a workspace that is clean, properly ventilated, and comfortable. Also, for optimal typing, you will need to get a table and not out your laptop or computer on your lap.


                      If you will be working for an extended period, make sure that you’re comfortable.

                      2. Fix Your Posture

                      If you want to type well, the correct posture will be seated, straight backed, and with your feet planted a little apart, flat on the ground. You wrists should also be positioned in such a way that your fingers can cover the keyboard. Tilt your head a bit as you can look at the screen properly as well.

                      Adjust your office chair so you’ll be able to easily play with the seat and get a proper posture.

                      3. Hold Your Posture

                      It is also very important that you keep this position as you type. Ensure that your posture is good, and this way, you will be able to avoid getting aches on your wrists. These aches have a way of slowing you down and keeping you out of rhythm.

                      Keep your back and shoulders from hunching, and while relaxation should be your key goal as you work on, also be sure to stay upright.


                      4. Familiarize Yourself with the Keyboard

                      The keyboard is your tool here, so you will need to get to know it. Fortunately for you, most keyboards that you see will make use of the same layout; the QWERTY layout. It is called that because of the letters that make the top left corner. You’ll also find that a lot of keyboards have keys around these main ones that do several tings.

                      Here’s a nice video to help you familiarize yourself with the keyboard:

                      So, work on memorizing the positions of the letter keys, as well as some of the most used punctuation marks. You will need to understand where they are without looking at the keyboard. This is the only way you can learn to type fast.

                      5. Close Your Eyes and Say the Keys out Loud as You Press Them

                      Another great way to get to know the positions of these letters is to look away from them and directly at the screen. Then, pronounce the keys as you press them and see if you’re correct. This step will go a long way in helping you to memorize the keys, and it can easily help you

                      6. Start Slowly with Touch-Typing

                      Improving your speed as you type is a matter of developing your skill over time. However, the quickest way to master typing will be touch typing. If this is your first time with touch typing, then you might spend a lot of time on this step. However, once you can type without looking at the keys, your speed will increase.


                      Now, this typing method might feel a bit alien, but you’ll improve with time.

                      7. Stick with It and Don’t Look at Your Hands

                      The whole essence of this step is to keep you from looking at your keyboard as you type, so that your fingers are made to learn how the keys work.

                      Again, you might find that your speed reduces when you begin, but just stick to it. Touch typing will help you to reach higher speeds and master it.

                      8. Practice, Practice, Practice

                      Mastering the touch typing technique will prove to be a bit finicky, but once your posture is up and you get your fingers where they should be, you can only improve by practicing.

                      Spare some time on a daily basis to practice and master both accuracy and speed. With continuous practice, you will also notice that you make fewer errors with time.


                      9. Check out Some Online Games

                      There are also some websites that can help you with your practicing. They score you and record your words per minute, so you can try improving your record and competing with others as well. Here’re some of the nice sites:

                      10. Dictation Practice

                      If you don’t know what you can type, another alternative to getting good practice is to listen to something and try to type as you hear the words. There is no limit to the kind of things you can type, and you can even make the practice process more fun. So, get an e-book, an online lecture, or listen to a talk show and type. You could watch a TV show as well.

                      11. Monitor Your Progress

                      Ensure that you keep track of the progress you make as you go on. But it is important that you don’t get obsessed with how many words you are able to type in a minute. Rather, ensure that you stay comfortable while you type. With time, your words per minute will increase, and you’ll be able to clock up some high numbers.

                      12. Get Some Formal Training If You Want

                      There are actually a lot of specially designed courses and programs that will boost your typing ability. If you’re willing to improve your skill, get any of these and see how well they work for you:

                      Don’t just finish reading this article and expect that you’ll type faster. You do need to work on your skills. It takes time to type fast but, practice makes perfect!

                      More Tips About Typing Faster

                      Featured photo credit: Cytonn Photography via

                      Read Next