Latest Blog Posts

How to Merge Cells in Excel with Data (7 Quick Ways)

Certainly, Excel is a popular and useful tool for arranging and manipulating data. Now, combining multiple cells is a common scenario while working ...

How to Copy Rows in Excel (7 Easy Ways)

Let's use an Employee List. This dataset includes the ID, Name, and Department in columns B, C, and D, respectively. Method 1 - Using the ...

How to Merge Cells Vertically Without Losing Data in Excel

To demonstrate our methods of merging cells vertically without losing data, we'll use the following dataset of some Book Records, and merge the books ...

Absolute Reference in Excel – 4 Examples

  The Absolute reference locks the referred cell. If you use an absolute reference, the cell won’t change after dragging the Fill Handle. ...

Difference Between Absolute and Relative Reference in Excel

In Excel, there are two main types of references: Relative and Absolute (although there is another reference type called a mixed reference). In this ...

How to Repeat Formula Pattern in Excel (8 Easy ways)

  In the following dataset, we have 8 columns and 9 rows. We have some empty cells where we will repeat formula patterns in various ways to ...

How to Repeat Rows for a Specified Number of Times in Excel

  Consider a dataset containing columns Item, their Grade, and Stock. We have to repeat some of its rows to make a bill. Method 1 ...

How to Combine SUMIF and VLOOKUP in Excel (3 Approaches)

  Overview: Excel SUMIF Function Objective: The function adds the cells specified by a given condition or criteria. Formula: ...

How to Transpose a Table in Excel: 5 Suitable Methods

Method 1 - Using Paste Special Tool to Transpose a Table in Excel STEPS: Select the whole table using a mouse. Press Ctrl + C, and a dancing ...

How to Transpose Rows to Columns in Excel (7 Quick Methods)

Below is a dataset that shows the year and Results of Students. Method 1 – Using Paste Special Command a) Pasting a Special Command from ...

How to Combine Duplicate Rows and Sum the Values in Excel: 4 Suitable Ways

Method 1 - Using Remove Duplicates Tool and SUMIF Function Steps: Copy the Customer column (make sure you start copying from the header ...

How to Transpose Array in Excel (3 Simple Ways)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Copy Formatting in Excel – 3 Methods

The following dataset showcases 'Order ID', 'Customer Name', 'Device', and 'Price' columns. The format of the first cell in Column E was copied to ...

Copy Worksheet to Another Workbook without Reference in Excel

This is our sample dataset. We want to show the Month and Demand on a new worksheet named “Demands Only” as shown in the image below. ...

How to Copy and Paste Thousands of Rows in Excel: 5 Methods

Method 1 - Copy and Paste Thousands of Rows from Address Bar Steps: Go to Address Bar and type in the range (in the sample dataset, it is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo