Archive for category General Tips

Highlight Differences In Lists Using Excel’s Go To Command

While there are several ways to compare lists in Excel and highlight differences, an option in the Go To feature provides a really quick and simple method.

Using AND() or OR() in Excel to Allow Multiple Conditions When Using IF()

Excel’s IF() function, in case you aren’t familiar with it, allows you to do one thing if a chosen condition is met, but do something else if that condition is not met. For example, when evaluating test scores you might want to display “Pass” if the score is 80% or better, but display “Fail” if […]


Combining the contents of multiples cells in an Excel spreadsheet is easy thanks to the Concatenate function.

Reset an Excel Spreadsheet – Delete your data but not your formulas

Have you ever built a spreadsheet and then wanted to re-use it, say for the next year, but realized you forgot to save a blank copy? That means you have to delete all the data that was entered into the workbook while being careful not to delete any of your formulas. That can be a […]

Find & Replace in Excel

Excel’s Find and Replace feature lets you quickly update information anywhere in your spreadsheet with just a few clicks.


Giving a name to a range of cells can make it much easier to write formulas or jump to a specific location.

Troubleshooting Formulas In Excel With “Evaluate Formula”

When you were in school, your math teacher probably insisted that you show your work to explain how you arrived at your answer. When you aren’t getting the result you expected from a formula in Excel, you can make Excel show you how it came up with its answer by using the Evaluate Formula feature.

Using Underline for Headings and Totals instead of Cell Borders

If you don’t like the continuous line you get when using cell borders to format totals or column headings in Excel, you’ll be glad to know that you can get the look you want with just a few clicks by combining the “comma” format with underlining.


Have you ever wanted to completely rearrange the data you have in Excel so that your rows become columns and your columns become rows? Maybe you receive data that’s not formatted the way you need it or maybe you just changed your mind about how you want a spreadsheet arranged. Either way, Paste Special – […]

Replacing An Excel Formula With A Number

Have you ever tried to copy numbers from one spreadsheet to another, only to discover that the cells you copied actually contained formulas? When you pasted them into the new location, each cell had an error instead of the number you wanted. Here are 3 different ways you can convert a formula into the number that is the result of that formula.