Excel Basics Archives - Page 34 of 124

How to Change Excel Sheet Direction from Right to Left (4 Methods)

Jul 10, 2024

The Excel sheet direction is by default from left to right. It shows the row numbers and sheet tabs on the left. The column numbers also start from ...

How to Change Excel Sheet Direction from Right to Left (4 Methods)

How to Change Positive Numbers to Negative in Excel (6 Ways)

Jul 3, 2024

The sample dataset contains Months and Loss columns, where we will change Loss to Profit. To do that, we will change the positive numbers to negative ...

How to Change Positive Numbers to Negative in Excel (6 Ways)

How to Insert Conditional Formatting Icon Sets Based on Percentage in Excel:5 Methods

Jun 6, 2024

Method 1 - Inserting Shapes Icon Sets Based on Percentage Steps To calculate the Percentages, select the cell D5, and then enter the following ...

How to Mirror Text in Excel: 5 Easy Ways

Jul 7, 2024

Method 1 - Use of Combined Functions to Mirror Text in Excel Steps: Select Cell C5. Insert the following formula. ...

How to Mirror Text in Excel: 5 Easy Ways

How to Add Custom Icon Sets in Excel Conditional Formatting (2 Ways)

Jun 6, 2024

To explore the methods, we’ll use the following dataset, which represents some students' scores on a class test, including the range of remarks. ...

How to Mirror Chart in Excel (2 Suitable Examples)

Jul 29, 2024

Example 1 - Mirror a Bar Chart in Excel Steps: Input the months in the range of cells B5:B16 and sales of different products of the ...

How to Mirror Chart in Excel (2 Suitable Examples)

How to Flip Excel Sheet from Left to Right (4 Easy Ways)

May 15, 2024

The sample Excel worksheet shows us the datasheet in the direction of right to left. Method 1 - Changing Default Direction Steps: ...

How to Flip Excel Sheet from Left to Right (4 Easy Ways)

How to Zoom in Excel Graph: 5 Methods

Jul 3, 2024

Method 1 - Create Dataset Put some months in column B. Insert the total unit sales of each month in column C. Finally, the total amount of ...

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

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