Latest Blog Posts

How to Change Font Size of the Whole Sheet with Excel VBA

In this article, I’ll show you how you can change the font size of a whole sheet with VBA in Excel. While working in Excel, we sometimes need to ...

How to Reference Cell by Row and Column Number in Excel (4 Methods)

This article will show you four ways to reference a cell by row and column number in Excel with sharp steps and vivid illustrations. In the following ...

How to Use Advanced Filter for Unique Records Only in Excel

We have a dataset that contains multiple identical entries. We want to remove identical entries and keep one of them. Use an Advanced ...

How to Count the Order of Occurrence of Duplicates in Excel (4 Methods)

Method 1 - Use COUNTIF Function This method allows you to count the order of occurrence of any type of values in Excel cells, such as text or ...

How to Use Advanced Filter to Copy Data to Another Sheet in Excel

In this article, we will demonstrate two methods to apply the Advanced Filter to copy data to another sheet in Excel. In the first method, we will ...

How to Make a Group of Cells Negative in Excel (5 Methods)

Here's an overview of making the entire range get negative values. We will use a simple dataset with numeric values in column C. ...

How to Combine Two Graphs in Excel (2 Methods)

  Dataset Introduction The following dataset represents the Salesman, Net Sales, and Target of a company. Our first graph will be based on ...

How to Use Cell Value as Worksheet Name in Formula Reference in Excel

Here, we have 3 worksheets—January, February, and March—containing the sales records of these 3 months for different products. We will use cell ...

How to Lock Certain Cells in Excel (4 Methods)

We will use a sample dataset containing Date, Product, Price, Quantity, and Sales. We'll lock some cells so they can't be edited. How to ...

How to Add Checkbox in Excel without Using Developer Tab: 3 Methods

Method 1 - Using VBA to Add Checkbox in Excel Without Developer Tab Steps: Press Alt + F11 to open the Microsoft Visual Basic for ...

How to Select a Range of Cells in an Excel Formula (4 Methods)

Dataset Overview Let’s consider an Excel worksheet that contains information about various outlets of a chain restaurant across the United States. ...

How to Use FormulaR1C1 Absolute Reference in Excel VBA

While working in Excel, you might hear the absolute cell reference. This type of cell reference remains unchanged if you copy, move or even use it in ...

How to Copy Multiple Cells to Another Sheet in Excel: 9 Methods

Method 1 - Copy Numerous Cells to Another Sheet Manually STEPS: Select the data from the source sheet. Right-click on your mouse. Select ...

How to Count Cells with Specific Text and Fill/Font Color in Excel (4 Ways)

In the dataset below, we have two columns: Book Name and Status. To the right, we have a separate column that will display cell count. Method 1 ...

Formula to Return Blank Cell instead of Zero in Excel (with 5 Alternatives)

The easiest way to to return a blank cell instead of zero in Excel is to use a formula. In this article we'll demonstrate and explain that formula, ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo