Latest Blog Posts - Page 284 of 587

Using Excel VBA to Hide Columns Based on Criteria – 6 Examples

Aug 11, 2024

The sample dataset showcases: Salesman, Product, and Net Sales. Example 1 - Apply Excel VBA to Hide Columns Based on the Cell Value X is ...

Using Excel VBA to Hide Columns Based on Criteria – 6 Examples

Excel Pivot Table Date Filter Not Working (2 Possible Solutions)

Jun 28, 2024

Reason 1 - All Cells of a Column Are Not in Date Format One of the most common reasons the pivot table date filter might not work is that all the ...

Excel Pivot Table Date Filter Not Working (2 Possible Solutions)

How to Print Labels from Excel in Word – 5 Steps

Aug 11, 2024

Step 1 - Prepare the Dataset The sample dataset contains name, address, and contact no. Create column headings: Name, Address, and Contact. ...

How to Print Labels from Excel in Word – 5 Steps

How to Make an Excel Spreadsheet Look Like a Form

Jun 10, 2024

Step 1 - Enable Form by Customizing Quick Access Toolbar First we need to customize the quick access toolbar so that the Form tab will appear in it. ...

How to Make an Excel Spreadsheet Look Like a Form

How to Select Data for a Chart in Excel – 2 Methods

Aug 4, 2024

This sample dataset showcases the Monthly Sales of a company in Different Regions. Method 1 - Using the Select Data Source Feature to ...

How to Select Data for a Chart in Excel – 2 Methods

How to Create a Stacked Pareto Chart in Excel (In Simple Steps)

Nov 11, 2025

In order to summarize values with bars and lines in descending order, it is best to use a Pareto Chart. It can visualize the dataset with elegance ...

How to Create a Stacked Pareto Chart in Excel (In Simple Steps)

How to Perform Numbering in One Cell in Excel (3 Smart Ways)

Nov 11, 2025

Sometimes we need to organize a set of data in a single cell to decorate our data. Numbering in Excel in One cell may be a very effective skill to ...

How to Perform Numbering in One Cell in Excel (3 Smart Ways)

How to Add 1 to Each Cell in a Column in Excel – 5 Methods

Aug 6, 2024

Method 1 - Using the Drag feature to Add 1 to Each Cell in a Column Steps: Create a dataset. In the two first cells (B5 and B6) of the ...

How to Add 1 to Each Cell in a Column in Excel – 5 Methods

How to Reduce Excel File Size with Pivot Table

Nov 11, 2025

Excel file sizes can get bigger if we have a large amount of data inside them. Decreasing the file size is one of the most important tasks whenever ...

How to Reduce Excel File Size with Pivot Table

How to Insert Page Number in Excel Cell Not in Header

Jun 28, 2024

Method 1 - Inserting Page Number in Excel Cell Step 1: Open VBA Window VBA has its own separate window. You must insert the code in this window, ...

How to Insert Page Number in Excel Cell Not in Header

Excel VBA to Hide Columns Using Column Number (6 Examples)

Nov 11, 2025

This article will teach us to hide columns using the column number with VBA in Excel. Usually, excel expresses columns with alphabets. But we can ...

Excel VBA to Hide Columns Using Column Number (6 Examples)

How to Hide Zero Values in Excel Pie Chart (3 Simple Methods)

Jun 16, 2024

In the sample dataset, we have a list of major subjects and the number of students who have taken them. No students have taken Human Resources and ...

How to Hide Zero Values in Excel Pie Chart (3 Simple Methods)

How to Show Only Working Area in Excel (3 Quick Tricks)

Jul 7, 2024

Download Practice Workbook Show Only Working Area.xlsx Method 1 - Use Excel Page Break Preview to Show Only Working Area In the sample ...

How to Show Only Working Area in Excel (3 Quick Tricks)

How to Add Text to Cell Without Deleting in Excel: 8 Easy Methods

May 29, 2024

Method 1 - Applying CONCATENATE Function Steps: Select cell C5. Write down the following formula in the cell. Make sure that you input the ...

How to Add Text to Cell Without Deleting in Excel: 8 Easy Methods

How to Use Formula for Page Number in Excel (6 Quick Ways)

May 28, 2024

Consider the dataset shown in cells B4:E26 below. The dataset is divided into two parts - the PC Shipment Tracker (which shows the Product names, the ...