Latest Blog Posts - Page 397 of 587

How to Space out Cells in Excel – 2 Methods

Aug 14, 2024

The following dataset contains extra space below the text. This is the sample dataset. To add space between text and cell borders: ...

How to Space out Cells in Excel – 2 Methods

How to Sum Columns by Color in Excel (6 Easy Methods)

May 13, 2024

The below dataset contains several items sold in quantity. Different fill colors have been applied to the Sold Quantity column. Method 1 – Using ...

How to Sum Columns by Color in Excel (6 Easy Methods)

How to Calculate Forecast Accuracy Percentage in Excel – 4 Easy Methods

Aug 3, 2024

Introduction to Forecast Accuracy Forecast Accuracy is the deviation between the forecast demand and the actual demand. It is also ...

How to Calculate Forecast Accuracy Percentage in Excel – 4 Easy Methods

Excel VBA: Split String by Character: 6 Useful Methods

Jul 6, 2024

Method 1 - Split Words of a String by Space Character Task: Split a text string in cell B3 by space character and output the substrings in cells ...

Excel VBA: Split String by Character: 6 Useful Methods

How to Move One Cell Down Using Excel VBA (4 Methods)

Jun 17, 2024

The dataset represents the sales of various salespersons in different regions. Method 1 – Using VBA to Move One Cell Down from an Active ...

How to Move One Cell Down Using Excel VBA (4 Methods)

Excel VBA: Split String into Cells (4 Useful Applications)

Nov 11, 2025

The article will provide you with some useful applications to split string(s) into cells by Excel VBA. We do this often to see necessary data ...

Excel VBA: Split String into Cells (4 Useful Applications)

How to Generate a Random String from a List in Excel (5 Suitable Ways)

Nov 11, 2025

In this article, you will learn 5 different ways to generate a random string from a list in Excel with ease. How to Generate Random String ...

How to Generate a Random String from a List in Excel (5 Suitable Ways)

How to Filter a Table based on Cell Values with Excel VBA (6 Methods)

Jul 27, 2024

Dataset Overview We've included a sample dataset in the figure below, from which we'll sift through values according to specific cell criteria. ...

How to Filter a Table based on Cell Values with Excel VBA (6 Methods)

Subtraction for Whole Column in Excel (with 5 Examples)

Jul 5, 2024

Below is a dataset that includes income and expenses. Method 1 - Subtraction of Cells Between Two Columns in Excel Steps ...

Subtraction for Whole Column in Excel (with 5 Examples)

How to Separate Date in Excel Using Formulas (5 Methods)

Jul 28, 2024

Dataset Overview For this demonstration, we’ll be utilizing the dataset provided below. In the range of cells from B5 to B10 on the left, you’ll ...

How to Separate Date in Excel Using Formulas (5 Methods)

How to Sum Filtered Cells in Excel (5 Suitable Ways)

Jun 23, 2024

Download the Practice Workbook Sum Filtered Cells.xlsm 5 Easy Methods to Sum Filtered Cells in Excel Let's consider a ...

How to Sum Filtered Cells in Excel (5 Suitable Ways)

How to Make Subtotal and Grand Total in Excel (4 Methods)

May 9, 2024

Consider the dataset as shown in the following screenshot. Here, the sales report contains Product Items, States, Price, Quantity, and Sales. We'll ...

How to Make Subtotal and Grand Total in Excel (4 Methods)

How to Sum Selected Cells in Excel (4 Easy Methods)

Jun 25, 2024

Method 1 - Using the SUM Function to Sum Selected Cells in Excel The following dataset shows sales for different months for a company. We'll ...

How to Sum Selected Cells in Excel (4 Easy Methods)

How to Remove Filter in Excel VBA (5 Simple Methods)

Apr 29, 2024

To remove filters from data, we are going to use the following dataset. It contains some product IDs in column B, product names in column C, and the ...

How to Remove Filter in Excel VBA (5 Simple Methods)

How to Use SUBTOTAL in Excel with Filters (With Quick Steps)

Jul 27, 2024

This article will demonstrate how to use the SUBTOTAL function in Excel with filters. Excel SUBTOTAL Function: Overview Objective: The ...