Latest Blog Posts

How to Lock Rows in Excel When Scrolling (4 Easy Methods)

Imagine you have the following dataset containing sales made by employees in different years. If you try to scroll down through the data, then ...

Generate Random Number with Mean and Standard Deviation in Excel

What Is Mean? The average of a group of values is known as the mean. It refers to a data set's values being distributed evenly. Generally, the mean ...

Excel VBA to Get Unique Values from Column (4 Examples)

We will use the following dataset to get unique values from a column. The dataset contains some products in column B and the country where the ...

How to Add Hyperlink to Cell Value in Excel Using VBA (4 Methods)

Method 1 - Embed VBA to Add Hyperlink from a Different Worksheet to a Cell Value in the Active Sheet Let’s consider the following dataset: In our ...

How to Hide Rows Based on Cell Value with Conditional Formatting in Excel: 2 Methods

Method 1 - Changing Text Color to Hide Rows Based on Cell Value with Conditional Formatting Steps: Select the cell range B5:D10. From the ...

Excel VBA: Split Sheet into Multiple Sheets Based on Rows

The sample dataset below will be used for demonstration. Procedure 1 - Build the Code Press Alt+F11 on your keyboard to open the VBA ...

Group Rows with Plus Sign on Top in Excel

Sometimes, when we group rows in Excel, the plus sign that appears as an outline can be confusing to use. We can change this by moving it on top for ...

How to Insert a Column if Greyed-out in Excel (9 Solutions)

Solution 1 - Change Microsoft Excel AppData with Windows Run Feature Steps: Close the Excel file. Press the Windows key + R to enter the Run ...

How to Print Selected Area in Excel on One Page (3 Methods)

Method 1 - Using File Tab to Print Selected Area in Excel on One Page Steps: Select the area that you need to print. We have selected B4:F12. ...

How to Rank Data in Excel Using Sorting (3 Methods)

Dataset Overview In this guide, we’ll work with a dataset containing student scores in an exam, their current CGPA, and corresponding names. ...

Excel VBA: Remove Duplicates Comparing Multiple Columns: 3 Methods

Method 1 - Remove Duplicates Comparing Specified Multiple Columns Using VBA in Excel Task: We want to remove duplicate students from the dataset by ...

How to Expand and Collapse Rows in Excel – 2 Steps

Step 1 - Collapse Rows in Excel Group your dataset. You can either use an auto outline (with subtotal rows) or group rows manually. Steps ...

Excel VBA: Remove Duplicates from an Array (2 Examples)

In this article, we'll demonstrate how to remove duplicates from an array using Excel VBA code. VBA Code Quick View Sub ...

Excel Macro: Convert Multiple Rows to Columns (3 Examples)

In this article, we’re going to show you 3 methods to convert multiple rows to columns in Excel Macro. For this purpose, we’ve taken a dataset with 3 ...

[Fixed!] Hyperlinks in Excel Not Working After Saving (5 Solutions)

We often use hyperlinks in Excel for many purposes but sometimes in some particular cases, it may not work. There are some common issues for that. In ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo