How to Remove Conditional Formatting in Excel but Keep the Colors

Conditional formatting is a fast and nice way to visualize data in Excel. It comes with many options but probably the one most use are the background colors: A color on a color scale is applied automatically based on the cell contents. For example, the lowest value in a range of cells in red color… Continue reading How to Remove Conditional Formatting in Excel but Keep the Colors

Mass Export in Excel: How to Save Same Sheet & Change Variable

Let’s assume the following situation: You have created an Excel file and want to export one sheet from it – many times with different settings. For example: Each sales person should receive their own sales numbers. The problem is that you have many sheets to export. And in practice the following happens: You have just… Continue reading Mass Export in Excel: How to Save Same Sheet & Change Variable

How to Multiply Existing Excel Formulas by Another Cell

You have created a nice analysis in Excel, but there is one problem: Values are shown in thousands and you want to convert them to millions. Or the other way around. Or you want to convert monthly values to annual values, multiplying them by 12. So, the problem: How to multiply existing Excel formulas by… Continue reading How to Multiply Existing Excel Formulas by Another Cell