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!

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!

Disable AutoSave in Office 365 / OneDrive: How to Switch it off for all files!

Disable AutoSave permanently in Office

The Office suite recently introduced a new AutoSave feature for OneDrive and SharePoint users. Probably with good intentions, Microsoft – like so often – did this exactly the wrong way: There is no option to disable it permanently and for all files at once. You can only do it for each file individually. What is… Continue reading Disable AutoSave in Office 365 / OneDrive: How to Switch it off for all files!

“Copy Again” in Excel: How to Easily “Re-Copy” the Same Cells!

Imagine this scenario: You have copied a range of cells in Excel. Then you type something in a different cell. Excel now “loses” the copied cell range and you have to go back and copy the same cells again. This might sound like a minor issue – when working with larger tables or workbooks it’s… Continue reading “Copy Again” in Excel: How to Easily “Re-Copy” the Same Cells!