Latest Blog Posts - Page 285 of 589

How to Unhide Columns in Excel All at Once (4 Quick Ways)

Jun 14, 2024

Take a look below for an example of a dataset where a number of columns are hidden. If you want to unhide columns simultaneously, you can use three ...

How to Unhide Columns in Excel All at Once (4 Quick Ways)

How to Put a Comma after 3 Digits in Excel (7 Useful Methods)

Jun 17, 2024

Below is a dataset showing 5 types of fruits a company sells throughout the year. Method 1 – Applying Custom Format Steps: Right-click on ...

How to Put a Comma after 3 Digits in Excel (7 Useful Methods)

How to Insert Character Between Text in Excel (5 Easy Methods)

Jun 15, 2024

The following dataset has the State and Number columns. Using this dataset, we will demonstrate how to insert characters between text in Excel. ...

How to Insert Character Between Text in Excel (5 Easy Methods)

How to Hide Columns with a Button in Excel – 4 Methods

Aug 9, 2024

This is the sample dataset. Method 1 - Using the Column Property to Hide Columns with Button in Excel 1.1. Hiding a Single ...

How to Hide Columns with a Button in Excel – 4 Methods

How to Add Text to Multiple Cells in Excel (10 Methods)

Jul 29, 2024

Dataset Overview Suppose you have a list of proverbs, which includes ten popular English proverbs. Now, you want to add text to these proverbs. In ...

How to Add Text to Multiple Cells in Excel (10 Methods)

How to Fit to Page in Excel – 3 Methods

Aug 12, 2024

The sample dataset contains multiple rows and columns. Method 1 - Utilizing the Page Layout Tab to Fit to Page in Excel Step 1: ...

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