Excel Basics Archives - Page 127 of 176

Excel VBA to Copy and Rename a Worksheet Multiple Times

May 22, 2024

Below is a sample sheet named “Dataset” which we will use to illustrate how to duplicate a sheet multiple times and rename it in Excel using VBA. ...

Excel VBA to Copy and Rename a Worksheet Multiple Times

How to Calculate Gross Profit Margin Percentage with Formula in Excel: 2 Methods

Jul 3, 2024

Method 1 - Excel Formula to Calculate Gross Profit Margin STEPS: Select the cell where you want to get the gross profit margin. Select cell E5. ...

How to Calculate Gross Profit Margin Percentage with Formula in Excel: 2 Methods

How to Copy Excluding Hidden Rows in Excel – 4 Easy Methods

Aug 3, 2024

This is the sample dataset. Method 1. Applying a Keyboard Shortcut to Copy Rows in Excel (Except Hidden Ones) Some rows are hidden in this ...

How to Copy Excluding Hidden Rows in Excel – 4 Easy Methods

How to Calculate Revenue Growth Rate in Excel (3 Methods)

Nov 11, 2025

The Revenue Growth Rate is a popular term for business organizations. It indicates how fast the company is growing. In this tutorial, we will show ...

How to Calculate Revenue Growth Rate in Excel (3 Methods)

Copy and Paste Is Not Working in Excel (9 Reasons & Solutions)

May 9, 2024

The following dataset represents the Product, Price, Quantity, and Total of a company. We'll use it to demonstrate the most common reasons for ...

Copy and Paste Is Not Working in Excel (9 Reasons & Solutions)

How to Convert Hours and Minutes to Decimal in Excel (2 Cases)

Nov 11, 2025

In this tutorial, we will learn how to convert Hours and Minutes to decimal in Excel. While working with time-related data we don’t need to keep the ...

How to Convert Hours and Minutes to Decimal in Excel (2 Cases)

How to Copy Rows in Excel with Filter (6 Fast Methods)

Jul 22, 2024

In this article, we will demonstrate 5 ways to copy filtered rows in Excel. We'll use the dataset below (B1:F16 cell range) to illustrate our ...

How to Copy Rows in Excel with Filter (6 Fast Methods)

[Fixed!] Cannot Copy Merged Cells in Excel (4 Solutions)

May 21, 2024

For illustration, we will use this sample dataset which represents the 5 bestseller books of 2020 at amazon.com. The book names are merged between ...

[Fixed!] Cannot Copy Merged Cells in Excel (4 Solutions)

How to Calculate Average of Multiple Ranges in Excel (3 Methods)

Jul 3, 2024

Our sample dataset contains player names and their scores in different games. We'll use this data to practice calculating the average of specific ...

How to Calculate Average of Multiple Ranges in Excel (3 Methods)

How to Solve Text Won’t Convert to Date in Excel (4 Problems & Solutions)

Jul 21, 2024

Dataset Overview Let’s consider a dataset containing employee information, including their joining dates. Unfortunately, these dates are not in the ...

How to Solve Text Won’t Convert to Date in Excel (4 Problems & Solutions)

How to Copy a Formula in Excel Without Dragging – 10 Methods

Aug 2, 2024

Use the following dataset to calculate the profit of this company. Method 1- Double-Clicking to Copy Formula in Excel without Dragging ...

How to Copy a Formula in Excel Without Dragging – 10 Methods

VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

Nov 11, 2025

Sometimes we need to re-organize columns into rows when working on a large dataset in Excel for better readability. Implementing VBA is the most ...

VBA to Transpose Multiple Columns into Rows in Excel (2 Methods)

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

Aug 9, 2024

Importance of Cell Number Formatting in Percentage Calculation To enter a percentage you have to use Number format. Steps: Enter a decimal ...

How to Add a Percentage to a Price with an Excel Formula – 2 Methods

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

Aug 6, 2024

The dataset showcases a list of colors with duplicates in Sheet1. To copy the unique colors to another worksheet in the same workbook. ...

How to Copy Unique Values to Another Worksheet in Excel – 5 Methods

How to Convert Text Date and Time to Date Format in Excel – 7 Methods

Aug 14, 2024

In the dataset below date and time values are in Text Format (they are left aligned). Method 1 - Convert Text Date and Time to ...