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.
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!
Microsoft claims that more than 1 bn. people use the Office suite. And if you look around – not only in the business world but also for private tasks, Excel is a very important software. So, how well do you know Microsoft Excel? Are you an Excel expert? Test your Excel knowledge with these 12… Continue reading Are you an Excel expert? Test your Excel knowledge here!
This problem is very annoying and not very reasonable: When you sort your Excel table, for example using filters, cell references messed up. Instead of linking to a cell in the same row, they suddenly refer to a cell in a different row. The dangerous part: Often, you want immediately notice it – and something… Continue reading Cell References Messed Up? How to Avoid Wrong Cell Links When Sorting in Excel
I love doing sports, especially running, but also biking and gym activities. I always record my runs and rides and like to analyze them afterwards in Garmin Connect and Strava. Sometimes, however, the results are obviously wrong. For example, when my heart rate monitor, which is connected to my watch, is running out of battery.… Continue reading Correct Wrong Strava and Garmin Results in Excel: Free Tool!
In times with an increasing amount of remote work, presenting Excel files through Zoom, Microsoft Teams, Skype, etc. seems to be the new normal. I often present day-in day-out my Excel files through screen sharing sessions. Depending on the audience, the task and the status of the file, the presentation should probably look as professional… Continue reading Screen Sharing Excel files with Zoom & Co Like A Pro: Easy Tricks!
You try to open an Excel file, but Excel doesn’t open it? Instead, a blank or empty Excel window is shown? This can be very annoying. Especially because it’s often not clear, what has happened. Google searches (to my experience so far) show many results, but nothing seems to be working. Or the steps in… Continue reading Excel Opens Blank Window When Double-Clicking On File? Easy Solution!
Many Excel users like to use the comment function in Excel. Unfortunately, they come with some disadvantages (displaced, wrong size, hiding content, bad for printing, often outdated, e.g.) so that I usually recommend not to use them. Instead, I recommend using a comment column. This article describes how to transform Excel comments to cells. Extract… Continue reading Extract Comment Text from Excel Cell: 3 Easy Methods (+Download)