Latest Blog Posts - Page 398 of 584

Excel VBA: Set a Range by Row and Column Number – 3 Examples

Aug 8, 2024

This is a quick overview. Method 1 - Set a Range by Row and Column Number Using the Cell Address in VBA To set B4:D13, use ...

Excel VBA: Set a Range by Row and Column Number – 3 Examples

How to Rearrange Rows in Excel (4 Ways)

Nov 11, 2025

Sometimes, while working in Microsoft Excel we may feel the need to rearrange rows according to our convenience. Suppose, we have a dataset like the ...

How to Make a Bulleted List in Excel (9 Methods)

Nov 11, 2025

In Microsoft Word, it is easy to make a bulleted list with just a single click. But in Excel is it possible? Yes, it is. Today in this article, I am ...

How to Make a Bulleted List in Excel (9 Methods)

How to Create Collapsible Rows in Excel (4 Methods)

Jul 3, 2024

The following Item Price List table shows the Month, Item, and Price columns. We will collapse the rows of this table. Method 1 - Creating ...

How to Create Collapsible Rows in Excel (4 Methods)

Auto Generate Invoice Number in Excel Template (4 Quick Steps)

May 28, 2024

Suppose we invoice a certain company repeatedly using an Excel Invoice Template. We want an auto generated invoice number every time we open the ...

Auto Generate Invoice Number in Excel Template (4 Quick Steps)

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

Apr 16, 2024

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

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

Generate Random Number with Mean and Standard Deviation in Excel

Jun 17, 2024

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

Generate Random Number with Mean and Standard Deviation in Excel

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

Jun 15, 2024

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

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

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

Jul 21, 2024

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 Add Hyperlink to Cell Value in Excel Using VBA (4 Methods)

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

Jul 3, 2024

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

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

Excel VBA: Split Sheet into Multiple Sheets Based on Rows

Jul 7, 2024

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

Excel VBA: Split Sheet into Multiple Sheets Based on Rows

Group Rows with Plus Sign on Top in Excel

Nov 11, 2025

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