Excel Basics Archives - Page 58 of 176

Create a Table in Excel Based on Cell Value (4 Easy Methods)

Jul 6, 2024

Method 1 - Using Table and Pivot Table to Create a Table in Excel Based on Cell Value We will first insert a Table using our dataset, and use a ...

Create a Table in Excel Based on Cell Value (4 Easy Methods)

How to Add Brackets to Negative Numbers in Excel (3 Easy Ways)

Jun 18, 2024

We will use the following dataset which displays the buying price and selling price of some products. Method 1 – Changing Cell Format to Add ...

How to Add Brackets to Negative Numbers in Excel (3 Easy Ways)

How to Create a Table Without Data in Excel – 2 Methods

Aug 14, 2024

Method 1 - Using the Format as Table Option to Create a Table Without Data Step 1: Select the cells you want to convert into a ...

How to Create a Table Without Data in Excel – 2 Methods

How to Mirror Table in Excel (4 Easy Methods)

Jun 16, 2024

We have a large Excel worksheet that contains information about several sales representatives. We want to mirror that table. Method 1 - ...

How to Mirror Table in Excel (4 Easy Methods)

How to Indent Second Line in Excel Cell

Nov 11, 2025

Indenting the second line in an Excel cell enhances readability and structure. It creates hierarchy and makes it simpler to distinguish different ...

How to Mirror Data in Excel: 3 Easy Methods

Jul 5, 2024

Method 1 - Link Cells to Mirror Data Steps: First and foremost, click on the B5 cell and insert the following formula. ='Sample ...

How to Mirror Data in Excel: 3 Easy Methods

Using an Excel Formula to Work with Positive and Negative Numbers – 6 Examples

Aug 9, 2024

This is an overview. Overview of Excel Formulas for Working with Positive and Negative Numbers Example 1 - Converting Negative Numbers to ...

Using an Excel Formula to Work with Positive and Negative Numbers – 6 Examples

How to Create Table of Contents in Excel with Hyperlinks (5 Ways)

Nov 11, 2025

Sometimes, the Excel workbook becomes large because of numerous worksheets. Because of having several worksheets, it is tough to overview all of ...

How to Create Table of Contents in Excel with Hyperlinks (5 Ways)

Excel Conditional Formatting Icon Sets with Relative Reference (2 Examples)

Jul 12, 2024

What Is Relative Reference? In Excel, a cell reference is typically relative. This means that the reference adjusts based on the cell’s location. ...

Excel Conditional Formatting Icon Sets with Relative Reference (2 Examples)

How to Create a Table with Existing Data in Excel

Aug 2, 2024

We will use a dataset containing information about some Sellers' Sales Amounts. It also includes the Region and Dates of the sales. STEP 1 ...

How to Create a Table with Existing Data in Excel

[Fixed!] Excel Not Adding Negative Numbers Correctly (4 Solutions)

Nov 11, 2025

In this tutorial, I am going to share with you 4 possible solutions to the problem of excel not adding negative numbers correctly. These solutions ...

[Fixed!] Excel Not Adding Negative Numbers Correctly (4 Solutions)

How to Unhide Very Hidden Sheets in Excel (2 Effective Methods)

Nov 11, 2025

Sometimes your worksheet may contain confidential information and in that case, hiding your worksheet may be one of the best options. Excel also ...

How to Unhide Very Hidden Sheets in Excel (2 Effective Methods)

How to Tab to Certain Cells in Excel (2 Easy Ways)

Nov 11, 2025

Sometimes, when filling out a form in Excel, the data entry cells may be scattered across the worksheet. Therefore, we want an easy way to go through ...

How to Tab to Certain Cells in Excel (2 Easy Ways)

How to Add Header in Excel (5 Quick Methods)

Jul 25, 2024

In this article, we will discuss some methods to add a header in Excel. We can insert a header on each page of our Excel worksheet, which typically ...

How to Add Header in Excel (5 Quick Methods)

What is an Unqualified Structured Reference in Excel?

Aug 2, 2024

The image below differentiates a Structured Reference from an Explicit Reference. Structured Reference and Its Types Structured ...