Excel Basics Archives - Page 58 of 176

How to Remove Drawing Tools in Excel (3 Easy Methods)

Jun 20, 2024

The dataset that we will use to remove the drawing tools contains various shapes as Excel objects. We put in multiple shapes to ...

How to Remove Drawing Tools in Excel (3 Easy Methods)

How to Automatically Hide Rows with Zero Values in Excel – 2 Methods

Aug 4, 2024

This is the sample dataset. Method 1 - Apply Excel VBA to Automatically Hide Rows with Zero Values 1.1 With an InputBox STEPS: Go ...

How to Automatically Hide Rows with Zero Values in Excel – 2 Methods

How to Print Gridlines in Excel Online (2 Easy Ways)

Nov 11, 2025

In Excel online, gridlines are applied to the worksheets by default. But when we print the worksheets, no gridlines are visible on the printed copy. ...

How to Print Gridlines in Excel Online (2 Easy Ways)

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