Excel Basics

How to Click One Cell and Highlight Another in Excel (2 Methods)

In this article, we will learn to click one cell and highlight another in Excel. In Excel, often we need to click one cell and highlight another cell ...

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

How to Divide a Group of Cells by a Number in Excel (3 Methods)

While performing some calculations in Microsoft Excel, we need to divide a group of cells by a number. We can divide a cell or the group of cells ...

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

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo