Excel Basics

How to Find and Replace within Selection in Excel (7 Methods)

Our sample dataset contains the sales report of some Items along with the relevant Sales Rep. Quantity, Unit Price, and Sales for each item are also ...

How to Hide a Formula but Allow Input in Excel – 2 Methods

This is an overview: Consider the following bank interest calculator: You want to allow users to input data in C4:C7, but you don’t ...

Select All Cells with Data in a Column in Excel (5 Methods+Shortcuts)

In this article we'll discuss 5 methods to select all cells containing data in a column, and 3 related keyboard shortcuts. We'll use the following ...

Multiple Excel Cells Are Selected with One Click: 4 Causes+Solutions

Method 1 - Disable the Extend Selection Mode If Multiple Cells Are Selected with One Click Look at the following screenshot. Only cell B5 is ...

How to Find and Replace Blank Cells in Excel (4 Methods)

The sample dataset contains student's names along with their Student ID and their Marks. Some students did not take the exam and so their mark is ...

How to Add Leading Zeros in Excel Text Format (11 Methods)

Method 1 - Add Leading Zeros Manually in Excel Steps: Go to cell D5 and manually insert the value of cell C5 with two zeros (00). ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo