Excel Basics

How to Select Cells with Certain Value in Excel (5 Methods)

Dataset Overview Occasionally, we need to locate and highlight cells with specific values in an Excel spreadsheet. Since Excel typically contains a ...

How to Fill Blank Cells with 0 in Excel (3 Methods)

Here's a sample dataset that we'll use. There are a lot of blank cells, which we'll fill with zero values. Method 1 - Apply the Go to ...

If a Cell Is Blank then Copy Another Cell in Excel (3 Methods)

Method 1 - Use IF Function to Copy Another Cell If a Cell Is Blank In the sample dataset, we want to copy the Employee IDs to the Output column. If ...

How to Delete Extra Pages in Excel (4 Methods)

To showcase how you can delete extra pages in Excel, we are going to use the dataset below. It contains some product items, the quantity of those ...

How to Find Reference Errors in Excel – 3 Methods

What is the Reference (#REF!) Error in Excel? The reference (#REF!) error is usually displayed when a cell referred to in the Excel formula is not ...

How to Drag Cells in Excel Using the Keyboard (2 Methods)

Method 1 - Dragging Values Vertically Down Using Ctrl+D The dataset shows the Employee ID, Full Name, and Department. Multiple people belong to the ...

[Fixed!] Spell Check Is Not Working in Excel (4 Solutions)

To explore the fixes, we’ll use the following dataset that represents some clothes’ prices. Reason 1 - Excel Can't Check Spell in a Cell ...

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

How to Group Cells with Same Value in Excel (3 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in ...

How to Check If Value Exists in Range in Excel (8 Ways)

We have the Product List and the Order List of the products of a company, and we want to check if the products of the Order List are available in the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo