Thank you for printing our article. Explore Lifehack for similar articles to help you improve your life.

Technology

# 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.

## 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.