How to Change Font in the Whole Excel Workbook

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.

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!

Custom Number Formats: Big Guide, Popular Codes and a Free Download

Custom Number Formats in Excel

Excel provides many default number formats. But often, these formats are not enough. For example: You want to display number in thousands or millions? Or have a thousands separator for percentage values? Or show a plus sign for positive values? In such case, you need to create a custom number format. In this article, you… Continue reading Custom Number Formats: Big Guide, Popular Codes and a Free Download

Force Cell to Text/Number Format in Excel: Easy Tricks!

You are changing the cell format, for example from “text” to “number” and nothing happens? Or the other way around, you want to enter a phone number but Excel automatically converts it to a number? Unfortunately, Excel is very unpredictable when it comes to text/number formatting. Here is what you should do in order to… Continue reading Force Cell to Text/Number Format in Excel: Easy Tricks!