How to Center Across Selection in Excel With Just One Click

Especially for headlines or table headings in Excel, merging cells is a great and fast way to center text across several cells. But merging cells comes with a few disadvantages. So, many professionals recommend using “Center Across Selection” instead. Unfortunately, the option is a little bit hidden. Here is how to apply it and how… Continue reading How to Center Across Selection in Excel With Just One Click

How to Remove Conditional Formatting in Excel but Keep the Colors

Conditional formatting is a fast and nice way to visualize data in Excel. It comes with many options but probably the one most use are the background colors: A color on a color scale is applied automatically based on the cell contents. For example, the lowest value in a range of cells in red color… Continue reading How to Remove Conditional Formatting in Excel but Keep the Colors

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 in Excel: Everything You Need to Know!

Custom Number Formats in Excel

Excel provides many default number formats. But often, these formats are not enough. That’s were custom number formats come into play. Let’s take a look some examples: 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,… Continue reading Custom Number Formats in Excel: Everything You Need to Know!

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!