Archive for category General Tips

COMBINING DATA FROM MULTIPLE CELLS USING CONCATENATE

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.

NAMED RANGES IN EXCEL

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.

TRANSPOSE COLUMNS AND ROWS IN EXCEL

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.

Excel – Worksheet Protection

If you want to keep part or all of a spreadsheet from being changed, you need Excel’s worksheet protection feature.

EXCEL – CONDITIONAL TOTALS USING SUMIF

Most Excel users know how to use the SUM function to get the total of a group of numbers. But did you know that Excel also gives you the ability to total just the numbers that meet your conditions?