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.
Category: Excel Features
In this category you find all articles about Excel features, such as “Remove Duplicates“, “Filter” etc.
Big Excel Model? How to Calculate Selected Cells Only
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.
Exchange Cells: Excel Hack of How to Swap Two Cells!
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.
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
How to See The Current Sheet Number & Total Number of Excel-Sheets
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
How to Convert Non-Adjacent Formula Cells to Values
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!
Easily Find & Select all Comments and Notes in Excel
Your Excel worksheet is full of comments and notes? Here is how to easily find and select all cells with a comment or note!
How to bulk insert IFERROR to existing Excel formulas!
We have already explored the IFERROR function in Excel. IFERROR (and IFNA) provide great ways to catch errors in Excel formulas and functions. Now, let’s take it to the next level: Bulk insert IFERROR and IFNA to existing functions. That means, you have many functions already and just want to wrap IFERROR or IFNA around… Continue reading How to bulk insert IFERROR to existing Excel formulas!
How to Easily Enter Phone Numbers in Excel Cells!
If I have to name the question I’m most frequently asked, this will probably among the top 3: How do I enter a phone number in Excel? The problem: When typing phone numbers, Excel recognizes them as numbers and removes leading zeros.
How to Zoom to Same Zoom Factor on All Excel Sheets
In this article you learn all the details about zooming in Excel: Three basic ways of applying a zoom level, how to set the same level on multiple (or all) worksheets in your Excel file and how to do it even faster.