Excel Basics Archives - Page 30 of 176

How to Make Name Tags in Excel (with Easy Steps)

Nov 11, 2025

Name Tags are used very often for practical purposes. This is a useful trick frequently used for efficient data management. In this article, I am ...

How to Make Name Tags in Excel (with Easy Steps)

How to Delete All Sheets Except One in Excel (2 Quick Methods)

Nov 11, 2025

While working in Microsoft Excel, sometimes we need to delete all sheets from a workbook except one sheet or the active sheet. But doing it one by ...

How to Delete All Sheets Except One in Excel (2 Quick Methods)

How to Delete Hidden Columns in Excel (2 Simple Methods)

Aug 2, 2024

Method 1 - Using the Inspect Document Feature in Excel to Delete Hidden Columns STEPS: Select column D. Right-click and choose Hide. ...

How to Delete Hidden Columns in Excel (2 Simple Methods)

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

Jul 4, 2024

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 All Rows Not Containing Certain Text in Excel?

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

Nov 11, 2025

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 Delete Empty Columns with Header in Excel (4 Easy Ways)

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

Jun 14, 2024

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 Create a Table from Another Table in Excel (3 Easy Ways)

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

Aug 3, 2024

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

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

How to Write CO2 in Excel (5 Easy Methods)

Nov 11, 2025

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

How to Write CO2 in Excel (5 Easy Methods)

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

Jul 9, 2024

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

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

How to Select Specific Columns in Excel – 4 Easy Methods

Aug 7, 2024

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

How to Select Specific Columns in Excel – 4 Easy Methods

How to Show Ruler in Excel (with Simple Steps)

Nov 11, 2025

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 Show Ruler in Excel (with Simple Steps)

How to Change Decimal Places in Excel Graph: 3 Methods

Jul 5, 2024

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

How to Change Decimal Places in Excel Graph: 3 Methods

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

Aug 6, 2024

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

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

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

Jul 8, 2024

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

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

Conditional Formatting with Data Bars Based on Another Cell in Excel

Nov 11, 2025

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