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.
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.
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!
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!
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!
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!
It is a very common task in Excel: Send single worksheets to a co-worker. Or save and share them with somebody else. How do you do that? In this article you learn two methods, step by step of how to e-mail single (or multiple) worksheets from a larger Excel file by attaching them to an… Continue reading E-Mail or Save Single Excel Sheets With These Simple Steps!
I’ve seen many examples in which you want to work with flag icons in Excel. That might be when you compare countries, markets, sales per region and so on. Instead of just writing long country names – or shorter but maybe not so intuitive abbreviations – you could insert flag icons. In this article, I’ll… Continue reading Flags in Excel: How to Easily Insert Country Flag Icons in Cells & Charts!
Often, you need to insert and work with the sheet name in an Excel sheet, for example if you are working with the ‘INDIRECT’-formula. Or, if you want to dynamically change headlines depending on the sheet name. If you don’t want to type the sheet name manually – which is very unstable – there are three ways to… Continue reading Insert Sheet Name In Cell: Easy! 3 Methods to Return the Worksheet Name
The new XLOOKUP function in Excel not only offers great advanced features, but can be also used for 2D XLOOKUPs. Before XLOOKUP, the most common way for searching in rows and columns at the same time was INDEX/MATCH/MATCH. A combination of XLOOKUP and XLOOKUP can do the same. Let’s see how it works and explore… Continue reading 2D XLOOKUPs: How to use the new XLOOKUP for searching in two dimensions