You have finished working on your Excel file and it basically looks fine. Most of the texts and numbers are in Calibri Font. But what, if you want (or need to…) change it? In the whole workbook? Here are some tips and tricks of how to change the fonts in the entire Excel file.
Your Excel worksheet is full of comments and notes? Here is how to easily find and select all cells with a comment or note!
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.
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!