Excel Basics

How to Delete All Rows Not Containing Certain Text in Excel?

In the following dataset containing information about some fruits, Apple is listed multiple times. Let's delete all the rows except those containing ...

How to Delete Empty Columns with Header in Excel (4 Easy Ways)

The article will provide you with some quick tricks to delete empty columns with a header in Excel. While working on an Excel worksheet, you may need ...

How to Create a Table from Another Table in Excel (3 Easy Ways)

Method 1 - Merging Multiple Columns to Create Table from Another Table in Excel Steps: We use the table below for this example: Select ...

How to Randomize a List Without Duplicates in Excel – 4 Methods

The dataset showcases a List of Stock Prices.   Method 1 - Using the INDEX, SORTBY, and SEQUENCE Functions Steps: Select B16 ...

How to Write CO2 in Excel (5 Easy Methods)

We often need to write different mathematical, chemical, or other types of expressions while presenting data in Excel. Most of the equations have ...

[Fixed!] Excel Default Font Is Not Changing (4 Quick Solutions)

We'll use the following simple dataset of 10 employees. The font is the default Calibri, and we want to change it to Arial. Solution 1 - ...

How to Select Specific Columns in Excel – 4 Easy Methods

The dataset showcases Product, Quantity, Unit Price, and Total Price. Method 1 - Using a Keyboard Shortcut to Select Specific Columns ...

How to Show Ruler in Excel (with Simple Steps)

Rulers are used to measure the height and width of cells in Excel. We can do this from the format section of the Home tab. But every time measuring ...

How to Change Decimal Places in Excel Graph: 3 Methods

Method 1 - Utilize Data Labels of Excel Graph to Convert Decimal Places STEPS: Insert the graph. For this, select the data. Go to the Insert ...

[Fixed!] Excel Superscript Not Working (6 Ideal Solutions)

There are various reasons why superscript formatting may not be working as expected in Excel. In this tutorial, we will discuss these reasons and ...

How to Increase the Font Size Using the Keyboard in Excel – 3 Methods

  This is the sample dataset. Method 1 - Using the Format Cells Feature Steps: Select the cell and highlight the text you ...

Conditional Formatting with Data Bars Based on Another Cell in Excel

In Microsoft Excel, there is a feature named Conditional Formatting that allows you to apply formatting to cells based on certain criteria. We can ...

How to Increase Character Limit in Excel Cell (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we ...

How to Remove Rows Containing Identical Transactions in Excel?

In many cases, we record transactions in Excel. And in various ways, we may include the same data in multiple rows which causes problems when we work ...

How to Limit the Scroll Area in Excel (3 Methods)

Dataset Overview We'll use a data set containing World Cup Winners and Runner Ups to demonstrate these methods. Method 1 - Manually Limit ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo