Latest Blog Posts

How to Fix “Fixed Objects Will Move” in Excel (4 Solutions)

Solution 1 - Save Excel Files as XLSX or XLS Files to Fix “Fixed Objects Will Move” Error Follow these steps: Go to the File tab. ...

How to Use Variable Row Number as Cell Reference in Excel

As shown in the below screenshot, we want the sum of a couple of numbers. We can simply get the sum by summing the range (i.e., B5:B11). However, if ...

How to Combine Two Bar Graphs in Excel (5 Ways)

For a company, we have some Selling Prices and Profits for different years, which we have represented in two different bar graphs. Using the ...

How to Copy Conditional Formatting to Another Workbook in Excel

Conditional Formatting is one of the most used Excel tools. Conditional Formatting allows us to format cells according to our criteria. In this ...

Compare Two Columns in Excel and Highlight the Greater Value (4 Methods)

The sample dataset contains information about the sales amount of some salespeople for two months. We will compare the sales of the first month with ...

How to Delete Rows Based on Another List in Excel: 5 Methods

Method 1 - Delete Rows Based on Another List by Applying the Excel COUNTIF Function and Sort Option Steps: Type the below formula in Cell D5 ...

How to Add a Checkbox in Excel (2 Steps + 4 Uses)

Most likely you see a checkbox that is mainly used for selecting or deselecting any option. Though the process of adding a checkbox in Excel is quite ...

Calculate Years and Months between Two Dates in Excel

To calculate years and months between two dates we are going to use this dataset. It contains some start dates and end dates, and we'll get the ...

How to Make Cells Independent in Excel (5 Methods)

The dataset below shows information about some people in a charity organization, including their names, ages, contributions per month, and ID ...

Combine Multiple Excel Files into One Workbook with Separate Sheets (4 Methods)

In this example there are three different Excel Files and each of them contain a different Sheet. Method 1 - Apply Move or Copy Operation to ...

How to Find Blank Cells in Excel (8 Easy Ways)

Method 1 - Use Go To Special Dialogue Box to Find Blank Cells in Excel In the below screenshot, we have the attendance of 6 students for 3 days. We ...

How to Copy Conditional Formatting to Another Cell in Excel (2 Methods)

If you use specific conditional formatting to highlight cells based on some specific conditions, you might want to copy the conditional formatting to ...

How to Unlock Cells without Password in Excel (4 Methods) 

This article illustrates how to unlock cells in Excel without a password with 4 different methods. Excel allows the feature to lock cells with ...

How to Skip Blank Rows Using a Formula in Excel – 8 Methods

The sample dataset contains blank rows. Method 1 - Using Keyboard Shortcuts to Skip Blank Rows in Excel Step 1: Select B5:F14, and ...

Using Excel VBA to Count Blank Cells in a Range – 3 Methods

This dataset contains blank cells.   Method 1 - Embed a VBA to Count Blank Cells in a Range with the COUNTIF Function Steps: ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo