Solutions

How to Use the Different Count Functions in Excel

Count functions are the most frequently used functions in Excel. In this article, we will discuss about the different 5 count functions in detail. There are 5 variants of count functions: COUNT, COUNTA, COUNTBLANK, COUNTIF and COUNTIFS. Below we will talk about their usages in detail. 1.      COUNT The COUNT function counts the numbers of cells that contains numbers in a designated range. Besides, it also counts the numbers in an array. And this range or array is the argument of the...

Read more »

How to Customize the Borders for Specific Ranges in Your Excel Worksheet

You can customize borders for specific ranges in Excel. And here we will introduce this feature in detail. Sometimes you need to use special borders for a certain range to make it different from other ranges. For example, in this worksheet, you need to add borders for the first row because it contains the column headers. Add Borders In this part, we will show you the steps to add borders. Select the target area. Next click the small arrow next to the button “Border”. ...

Read more »

How to Quickly Insert and Delete Line Breaks in Batch in Excel Cells

Now you can quickly insert line breaks in batch by using the shortcut keys and the find and replace feature. In our previous article 2 Quick Tips to Wrap Long Texts in Excel Cells so that All Contents are Visible, we have introduced two methods to wrap long text in Excel cells. Actually, if you use the “Ctrl + Enter”, you are also adding line breaks into cells. But you can only add for a cell each time. Here we will talk about insert and delete line breaks in batch. Insert Line...

Read more »