Excel Basics

If Checkbox Is Checked Then Apply Formula in Excel (4 Methods)

Here's the data set we will use to insert checkboxes and apply formulas based on whether they are checked. Method 1 - Apply Formula Based ...

How to Select All Cells with Data in Excel (5 Methods)

Method 1 - Select All Cells with Values Using the ‘Go To Special’ Command The dataset below has data on several areas of fruit sales date-wise. ...

How to AutoFill Formula When Inserting Rows in Excel (4 Methods)

We have some salespersons along with their Sales amount and Sales Commission. The Commission is 10%. We'll use it to demonstrate how to AutoFill ...

The AutoFit Row Height is Not Working for Merged Cells in Excel – 2 Solutions

Solution 1 - Use an Updated Version of MS Excel (2010, 2013, 2016, 2019, 2021, 365 Versions) This is the sample dataset. The Product column ...

[Fixed!] Arrow Keys Not Moving Between Cells in Excel (2 Ways)

A typical problem with arrow keys is that they move the spreadsheet but not the pointer. In this tutorial, we will illustrate how to fix arrow keys ...

How to Remove Blank Cells from a Range in Excel (9 Methods)

We have a data range (B4:E12) that contains sales data for several electronic products (Date-wise). You can delete blank cells manually by selecting ...

How to Make Empty Cells Blank in Excel (3 Methods)

The sample dataset below will be used for illustration purpose. It contains some products in column B and the total sales of each product in column ...

How to Deal with Blank Cells That Are Not Really Blank in Excel (4 Ways)

Sometimes you may think a cell is blank because there’s nothing visible in it. But it may not actually be blank. There might be a formula that ...

How to Move a Group of Cells in Excel (4 Easy Ways)

In this article, we will demonstrate how to use multiple Excel features and keyboard shortcuts to move a group of cells in Excel, be they in rows, ...

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 Select Cells in Excel Using Keyboard (9 Ways)

Sometimes you need to Select Cells in Excel using Keyboard Shortcuts When working with a large dataset. Keyboard Shortcuts make it easier to Navigate ...

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 Lock Cells in Excel When Scrolling (2 Easy Ways)

In this tutorial, we are going to show you how to lock cells in Excel when scrolling. After this article, you will be able to lock a specific range ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo