Latest Blog Posts

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, ...

How to Copy Exact Formula in Excel (13 Methods)

Copy and Paste is one of the commonly performed activities while working with Microsoft Excel. We can copy any text, formula, or format in Excel. ...

Excel VBA: Find the Next Empty Cell in Range: 4 Examples

We’ve used a dataset that contains a sale list of a super shop. The dataset has a bunch of empty cells and we want to find them before performing any ...

Excel VBA: Delete Sheet If It Contains Name (4 Ways)

While working with a large Microsoft Excel, sometimes unnecessary data will appear in front of us, and we need to delete unnecessary data and the ...

How to Count Only Visible Cells in Excel (5 Tricks)

Usually, we can use the COUNTA function to get the count of existing rows in a dataset. However, when rows are hidden manually or through applying ...

How to Create Dynamic Drop Down List Using VBA in Excel

Let’s say we have a dataset where Employee Name, Company Name, and Business Addresses are displayed. We want a dynamic drop-down list where we can ...

How to Make a Dynamic Data Validation List Using VBA in Excel (3 Steps)

Step 1 - Create a Dynamic Name Range Go to the Formulas tab and select Name Manager. As a result, a Name Manager window will appear. ...

Delete Sheet Not Working in Excel (2 Solutions)

Solution 1 - Unprotect Workbook Structure While Delete Sheet in Excel is Not Working Overview If you’re unable to delete a sheet in Microsoft ...

How to Select a Range of Cells in Excel (9 Methods)

We will use the following dataset to illustrate selecting cells. Method 1 - Click & Drag to Select a Range of Cells in Excel For ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo