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 15 Great Macbook Accessories To Improve Productivity 2 7 Best Outdoor Security Cameras For Better Home Security 3 10 Best VPNs to Browse the Internet More Securely 4 10 Best Monitors for Your PC Under $100 5 10 Best Spy Apps for iPhone in 2020

                      Read Next


                      Published on November 19, 2020

                      15 Great Macbook Accessories To Improve Productivity

                      15 Great Macbook Accessories To Improve Productivity

                      When looking to improve your workflow, you need to have a proper computer. And one of the most appealing computers out there is macbooks. These sleek transportable computers allow you to work anywhere at any time and provide a lot of functionality to their users.

                      But sometimes, that’s not enough. In so many cases, you’re looking for more.

                      While you could go for some productivity apps, there are actually a lot of macbook accessories available that will make your life easier in many ways. These extra accessories will allow your macbook to charge faster, hold more data, or keep it safe and protected while you travel around.

                      Beyond that, there is a wide variety of accessories to pick from as many companies have jumped onto the bandwagon of supply to macbook users. Below we’ve listed off some of the greatest macbook accessories that’ll benefit your computer.

                      What Makes For Great Macbook Accessories?

                      Before getting into the list, we wanted to go over the criteria for what makes for great macbook accessories. The items that we’ve picked from this list will have the following criteria:

                      • Reasonably priced – Accessories themselves shouldn’t break the bank compared to the large initial investment of a macbook.
                      • Usability – All these accessories are practical in various situations, however, they also have extra features that make them useful in a few situations beyond their obvious functions.
                      • Compact – Workflow is also about space in most circumstances. As such, anything that’s too bulky doesn’t help much. These accessories are either large on purpose – for storage of other items – or are nice and compact so they won’t get in the way.

                      A USB Drive To Store Files Quickly Without Accessing The Cloud

                        While you can always access the Cloud at any time, sometimes accessibility can be cumbersome or it takes time. Instead of trying to access files that way, getting a USB flash drive can save you plenty of time. Especially if your work entails providing presentations.

                        The SanDisk Ultra Dual Drive is great as it offers USB-C and USB-A connectors allowing you to plug into virtually any device and transfer files and more between computers. Also, USB drives boast several hundred gigabytes these days making them solid storage devices.

                        Buy SanDisk Ultra Dual Drive here.

                        Compact Charger That Does More Than Charge

                          Your default charger that comes with your MacBook is a good option for a charger, but these days chargers can offer so much more. This can help you speed up your workflow as you can be charging other devices or using the charger for other uses beyond charging.


                          In the case of the Anker PowerPort charger, it is more compact than the default charger. It also offers another USB-C connector allowing you to rapidly charge another gadget with it.

                          Buy Anker PowerPort charger here.

                          Port Adapter For Those With Multiple Devices

                            One of the hard restrictions with a macbook is that it only has two USB-C ports. This is manageable for people with fewer gadgets but if you’re the kind who has several, it can interrupt your workflow if you need a particular device and you can’t charge it or access it.

                            In this situation, a port adapter from Satechi can help. It offers multiple USB-C ports allowing you to use multiple devices. This can also help in organizing cords which we know can disrupt work. If the USB-C ports aren’t enough, it also comes with an SD card reader and ethernet cable port too.

                            Buy Satechi Multi-Port Adapter here.

                            A USB Cable That Isn’t As Intrusive Or Cumbersome To Use

                            The USB-C cable that comes with Macbooks is small and is used to hook to an external monitor. By adding more length to them, you can have better cable management. One option that we found to be ideal was the Nomad Kevlar cable which offers enough length to do what you want while giving you more space to work with.

                            Buy Nomad Kevlar USB-C Cable here.

                            Screen Cleaning Your Laptop To See What You’re Doing

                            Dust, particles and splotches are to be expected on laptop screens after a while. While you can work around these, sometimes they can obscure your vision at times. The same can apply to all devices these days.

                            The only problem with many solutions on the market is that they can damage screens. Fortunately, we found a screen cleaning solution that doesn’t harm screens. ScreenDr Professional screen cleaning kit comes with a spray that’s safe for screens and an antimicrobial microfiber cloth to ensure you make the most of the spray.

                            Buy ScreenDr Professional Screen Cleaning Kit here.


                            Card Reader That Speeds Up Photo Transfer Time

                              If you’re looking for a standalone card reader for your work, getting a device designed for photo transferring and reading is essential. One of the best macbook accessories in this category we found was the Vanja card reader.

                              This one is able to read SD and MicroSD cards while also transferring the pictures to a computer with ease thanks to its USB-C and USB 2.0 port options. It’s also small making it easy to carry around and is cheap to buy making it a great choice to pick up if you deal with plenty of pictures.

                              Buy Vanja Card Reader here.

                              Protective Sleeves To Protect Your Laptop From Harm

                              For those who are travelling the last thing that you want is your laptop to get damaged for whatever reason. Even though you’re not likely to drop it as frequently as your phone, having a sleeve for a laptop to be in can save you time.

                              One sleeve that we found interesting was the Native Union sleeves. They are made of tear-resistant material with genuine leather accents. Its interior is soft as well preventing scratches from your laptop. It also offers a pocket area where you can store cables and other macbook accessories easily.

                              Buy Native Union’s laptop sleeve here.

                              Car Charger For Charging On The Go

                                For the person always driving around, a car charger is always a helpful tool to have when you’re on the go. The one from Anker is particularly helpful in a number of ways. Not only can this charge your macbook, but it also has an additional port for you to charge your phone if needed.

                                It’s not the fastest charger out there when compared to the Macbook Pro adapter but it’s the highest in the market with an output power of 30 watts. For comparison, the second-fastest charging connector offers an output of 18 watts. Aside from that the charger has an illuminated LED ring for you to see it and the connectors late at night. It also has a function that ensures devices don’t experience surges or overheating from the charger itself.

                                Buy Anker PowerDrive car charger here.


                                USB-C to USB-A Adapter Grants Access To Older Models

                                If your older macbook still works but has files you want that you didn’t back up that you want this makes it easier to access them. It also allows you to access devices that have USB-A slots only. This can save you a lot of time if you are moving between older and newer devices.

                                Buy Thunderbolt Adapter here.

                                A Hardshell Case For Added Protection

                                A sleeve is good for travel, but when you’re using it, having an extra layer of protection can be nice. Beyond that this hardshell case can also serve as additional protection from scratches and bumps too.

                                Buy Incase Textured Hardshell case here.

                                Alternative Sleeve For Those With Tighter Budgets But Want Protection

                                  If you are looking for an appropriate laptop sleeve but aren’t looking to spend too much, AmazonBasics brands are a good alternative. Their sleeves are elegant and still offer good protection from scratches as well. It also has a few pockets for small essentials too.

                                  Buy AmazonBasics laptop sleeve here.

                                  A Hub That Accommodates Several Ports At Once

                                  We’ve already mentioned a port before being a huge time saver thanks to it having various ports for different devices. This one is a great alternative as while it doesn’t offer as many USB-C ports, it offers more variety. Paired up with the design being the same color as the MacBook Air, it offers two USB-C connectors, two USB 3.0 ports, an HDMI port and SD and microSD card readers.

                                  Buy Satechi Type C Pro Hub here.

                                  Earbuds To Deal With Fewer Headphone Cords

                                    Cords are a common problem when boosting productivity at the desk and one way to mitigate them is to go wireless. If you are thinking about that, one option to consider is the Soundcore earbuds. These are cheaper than the traditional AirPods from Apple which can save you money.


                                    Furthermore, they deliver great sound and are connected via Bluetooth. The beauty of these earbuds is they can also cancel sound despite them being so compact. They also offer touch control allowing you to pause, play, skip music and answer calls.

                                    Buy Soundcore Wireless Earphones here.

                                    Desktop Stand To Save Desk Space

                                      Desk space is another crucial part of productivity as things can get in the way and obstruct your work. In cases where you don’t need your laptop at the moment, having a stand where you can set it aside can be helpful.

                                      In those situations, we recommend the Twelve South Book Arc. This neat Macbook accessor can save a tonne of space since it requires you to close your laptop in order to insert it into the stand. It also keeps it elevated from the surface which can protect it from spills

                                      Buy Twelve South BookArc desktop stand here.

                                      A Comfortable And Easy To Use Mouse For Faster Working Speed

                                      The last of the macbook accessories we’ll talk about is a proper mouse. Logitech offers fantastic mouses and their Logitech MX Master 3 is one of the greatest wireless mouses out there. It’s ergonomic design, customizable buttons and insanely precise movement is fantastic. It also comes with a scrolling wheel for precise scrolling.

                                      The battery power can last for months between charges and like all Logitech devices, it comes with a USB-C connector for charging.

                                      Buy Logitech MX Master 3 Wireless Mouse here.

                                      Bottom Line

                                      There are many macbook accessories out there to improve your workflow. Taking the time to do research and invest in some of the best ones though will save you plenty of time, money and energy in the long term. At the same time, all of these accessories can help you with specific needs for whatever you are doing.

                                      Featured photo credit: Viktor Ritsvall via

                                      Read Next