Excel Basics Archives - Page 163 of 176

How to Convert Multiple Rows to a Single Column in Excel

May 15, 2024

In the sample dataset, there are three rows: Team Red, Team Blue, and Team Green, with multiple columns. The goal is to convert it into a single ...

How to Convert Multiple Rows to a Single Column in Excel

How to Insert Row in Excel (7 Methods)

Jul 10, 2024

Dataset Overview In this dataset, let’s focus on a rapidly growing company. The company maintains an employee database that includes department ...

How to Insert Multiple Rows in Excel (6 Easy Methods)

Nov 11, 2025

Insertion of rows into Excel dataset is quite basic and one of the most frequent tasks we do. Insertion of a single row is super handy but the ...

How to Insert Multiple Rows in Excel (6 Easy Methods)

How to Insert Blank Rows After Every Nth Row in Excel (4 Methods)

Jun 25, 2024

Suppose you have the following dataset: Method 1 - Using the Sort and Filter Feature Steps: Create a new column and insert 1 and 2 ...

How to Insert Blank Rows After Every Nth Row in Excel (4 Methods)

How to Merge Rows Without Losing Data in Excel (5 Easy Ways)

Jul 4, 2024

In Excel, merging multiple rows, columns or cells is a common task. However, the standard merging procedure only keeps data from the upper left cell. ...

How to Merge Rows Without Losing Data in Excel (5 Easy Ways)

How to Compare Two Excel Sheets for Duplicates (5 Quick Ways)

Jul 5, 2024

Method 1 - Viewing Two Excel Sheets Side by Side to Find Duplicates Let’s consider we have an Excel workbook with two sheets. Here, we will ...

How to Compare Two Excel Sheets for Duplicates (5 Quick Ways)

How to Sum a Column in Excel (10 Easy Methods)

Aug 1, 2024

Download Practice Workbook Calculating the Sum of a Column.xlsx Method 1 - Use Arithmetic Formula Steps: Go to cell C12 and insert ...

How to Sum a Column in Excel (10 Easy Methods)

How to Add Rows with Formula in Excel: 5 Easy Methods

May 29, 2024

Method 1 - Apply Simple Mathematical Expressions Steps: We have the rows with values in them. Need to calculate the content of the rows in ...

How to Add Rows with Formula in Excel: 5 Easy Methods

How to Insert a Column in Excel (6 Easy Ways)

Jul 13, 2024

Method 1 - Using the Column Heading Context Menu Right-click on the column heading to open the context menu. Select the Insert option. A ...

How to Insert a Column in Excel (6 Easy Ways)

How to Sum the values in a Column in Excel – 7 Methods

Aug 15, 2024

Download Practice Workbook Download the workbook. Add the Sum of a Column.xlsx This is the sample dataset. Method 1 - ...

How to Sum the values in a Column in Excel – 7 Methods

How to Change the Row Height in Excel – 6 Methods

Aug 15, 2024

This is the sample dataset. Method 1 - Using Row Height Command Steps: Select B14:D14. Go to: Home >> Cells >> Format ...

How to Change the Row Height in Excel – 6 Methods

How to Use Multiple IF Statements with Text in Excel (6 Methods)

May 20, 2024

Below is a dataset with the examination records of some school students. Our objective is to find the overall result of each student based on their ...

How to Use Multiple IF Statements with Text in Excel (6 Methods)

Formula to Find Duplicates in Excel (6 Suitable Examples)

Jun 14, 2024

Method 1 - Using Logical Formula with COUNTIF to Find Duplicates in One Column in Excel Consider a column of item names like fruits in ...

Formula to Find Duplicates in Excel (6 Suitable Examples)

How to Remove Duplicates but Keep the First Value in Excel

Jul 8, 2024

Here we’ve got a data set with the Names, IDs, Marks, and Grades of students in an examination of Sunflower Kindergarten. Our objective is to delete ...

How to Remove Duplicates but Keep the First Value in Excel

How to Remove Duplicates Based on Criteria in Excel – 7 Methods

Aug 3, 2024

The following dataset contains “Customer Name” and “Item Sold” columns. There are duplicate values. Method 1 - Using an Advanced Filter to ...