If you often work with Microsoft Excel you might come to the point when standard functions won’t solve your problems any longer. In such case, you might have to start working with VBA macros. Of course, you can record steps in VBA, but usually you start from the opposite direction: You google a solution for… Continue reading How to Insert New VBA Module in Excel & Paste Macro Code
Author: Henrik Schiffner
Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.
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 Find and Select All (Partial) Strikethrough Cells in Excel!
This is a common scenario: You have sent an Excel file to a coworker and received the revised version back. Unfortunately, your colleague has only highlighted the changes using the strikethrough formatting. Even worse, in many cases only parts of cells are crossed out. But don’t worry – help is here! In this article you… Continue reading How to Find and Select All (Partial) Strikethrough Cells in Excel!
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.
Scroll to Same Cell on All Excel Sheets: 3 Easy Methods!
You have finished working on your Excel file and just putting on final touches. Now, you want to make sure that the next user of your Excel file opens it on exactly the correct position. For example, scroll on all sheets to cell A1. Here is how to do that with 3 simple methods.
Merge Sheets: Easily Copy Excel Sheets Underneath on One Sheet!
Let’s assume you have many worksheets, all in the same structure. Or they are at least in a similar structure. Now, you want to combine them into one worksheet. For example copying them underneath each other so that you can conduct lookups or insert PivotTables. In this article, you learn four methods to merge sheets… Continue reading Merge Sheets: Easily Copy Excel Sheets Underneath on One Sheet!
List of all Files and Folders: How to Easily Insert a Directory in Excel!
You probably don’t need this every day: But once a file you might want to have a list of all files within a folder or directory in Excel. The good thing: There are many methods available. If you Google it, you will find a lot of different methods to create a file list in Excel.… Continue reading List of all Files and Folders: How to Easily Insert a Directory in Excel!