Excel Basics

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

Excel VBA to Copy Multiple Sheets to New Workbook

Copying multiple sheets from one workbook to another manually is prone to errors and can become tedious with lots of sheets. In this article, we will ...

How to Copy a Sheet to Another Sheet in Excel (5 Easy Ways)

To showcase copying sheets, we’re going to consider the following sheet named Dataset. We will copy this sheet to a new sheet. Method 1 - ...

How to Insert Rows Automatically in Excel (4 Ways)

The dataset below contains the names, Regions, and Ranks of some sales representatives. We need to insert rows into the dataset automatically. ...

How to Turn Off Scroll Lock in Excel (2 Ways)

Scroll Lock in Excel significantly impacts scrolling, cell selection, formula auditing, data entry, and even macro recording. For these reasons you ...

Editor choice How to Turn Off Scroll Lock in Excel (2 Ways)

How to Merge Duplicate Rows in Excel (3 Methods)

Method 1 – Using the Consolidate Command Steps: Select a blank cell. Go to the Data tab > Data Tools group > Consolidate. The ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo