Today, I have a quick tip for you: Do you want to change the grouping direction in Excel? Usually when you use groupings on rows, the small + or – sign is below the grouped data. The same for columns: The little + and – sign for showing or hiding grouped columns is located on… Continue reading How to Change Grouping Direction Above / Left of Data in Excel?
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
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
You are working on an Excel file and have used cell background colors? In such case you might want to insert a legend or table of colors used in your sheet or workbook. Here are three methods that might work for you.
Today I have a tip for you if you work with very large Excel models. Those, which take minutes or up to hours to calculate. You can calculate selected cells only.
Sounds simple: Exchange cells in Excel. And actually it is. Here is what to regard in you a) want to exchange all references as well or b) keep the references as they are when you swap two cells.
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
Working with large Excel files with many worksheets can be frustrating. Especially finding things and keeping an overview is troublesome. One (small) feature might come in handy: See the sheet number of the current worksheet and the total number of worksheets. For example, like this: “Sheet 5 / 12”. You can enable this with just… Continue reading How to See The Current Sheet Number & Total Number of Excel-Sheets
In this article we take a look at how to remove formulas from cells and replace them by their calculated values. But even more: We explore, how to deal with filtered lists or if you only want to convert some selected Excel cells to values. Let’s get started!
Your Excel worksheet is full of comments and notes? Here is how to easily find and select all cells with a comment or note!