Latest Blog Posts - Page 37 of 411

How to Count Number of Columns in Excel: 5 Methods

May 21, 2024

Method 1 - Using Status Bar to Count Number of Columns in Excel Select the headers of the chart or dataset (or a particular row, which doesn’t ...

How to Count Number of Columns in Excel: 5 Methods

How to Swap Columns and Rows in Excel – 9 Methods

Aug 12, 2024

This is an overview. This dataset includes Employee Information: ID, Full Name, Designation, Department, and Annual Salary. ...

How to Swap Columns and Rows in Excel – 9 Methods

Excel Assign Macro to Button (3 Suitable Examples)

Jul 9, 2024

To demonstrate how to assign a macro to a button, we'll use a simple dataset containing student information. We'll sort this data according to the ...

Excel Assign Macro to Button (3 Suitable Examples)

How to Create a Formula in Excel to Calculate Percentage

Jun 17, 2024

Watch the Video – Create a Formula in Excel to Calculate Percentage Method 1 – Calculate the Percentage Formula to Compare Values ...

How to Create a Formula in Excel to Calculate Percentage

Excel Not Filtering Entire Column (9 Reasons with Solutions)

Jul 5, 2024

Here are some cases of Excel not filtering the entire column. Excel Not Filtering Entire Column: 9 Possible Reasons with Solutions ...

Excel Not Filtering Entire Column (9 Reasons with Solutions)

How to Fix “Compile Error in Hidden Module” in Excel (6 Reasons with Solutions)

Jul 17, 2024

What Is "Compile Error in Hidden Module" in Excel VBA? A "Compile Error in Hidden Module" is a security alert in Excel VBA. It usually occurs when ...

How to Fix “Compile Error in Hidden Module” in Excel (6 Reasons with Solutions)

How to Swap Axis in Excel: 3 Practical Examples

Jul 5, 2024

Example 1 - Apply the Select Data Feature to Swap Axes Right-click on the chart area and choose “Select Data” from the list options. ...

How to Swap Axis in Excel: 3 Practical Examples

How to Fix Excel Runtime Error 13 Type Mismatch in VBA

Jun 16, 2024

The Runtime Error 13 Type Mismatch in VBA is one of the most common types of errors while using VBA and occurs if the data type that is given does ...

How to Fix Excel Runtime Error 13 Type Mismatch in VBA

Using Excel VBA to Count Files in Folders and Subfolders – 4 Examples

Aug 10, 2024

How to Launch the VBA Editor in Excel Utilizing the Module Tool: Open your workbook and click Visual Basic in the Developer tab. ...

Using Excel VBA to Count Files in Folders and Subfolders – 4 Examples

Using the Character Code to insert a Check Mark in Excel – 5 Examples

Aug 14, 2024

This is an overview. Character codes depend on the Font. In Wingdings, the character code for the check mark is 252 and the ...

Using the Character Code to insert a Check Mark in Excel – 5 Examples

How to Fix If VBA ‘Object Variable’ or the ‘With Block Variable’ Not Set in Excel (2 Solutions)

Jun 16, 2024

How to Launch VBA Editor in Excel Steps: Press Alt + F11 to open your Microsoft Visual Basic. Press Insert > Module to open ...

How to Fix If VBA ‘Object Variable’ or the ‘With Block Variable’ Not Set in Excel (2 Solutions)

Excel VBA to List Files in the Folder and Subfolders – 3 Examples

Aug 4, 2024

This is an overview. Key Concepts i. Dir Function The Dir function returns the first file name in the specified folder. ii. File ...

Excel VBA to List Files in the Folder and Subfolders – 3 Examples

Excel VBA to List Files in Folder with Specific Extension

Jul 20, 2024

In this article, we will show 5 simple ways to use Excel VBA to list the files in a folder with a specific extension. In addition, we will show the ...

Excel VBA to List Files in Folder with Specific Extension

How to Sum If Cell Contains Number and Text in Excel

May 16, 2024

The following dataset contains sales records of the Continental Group for January. It includes information such as the date of the sale, the name and ...

How to Sum If Cell Contains Number and Text in Excel

Sparklines Are Not Showing in Excel (6 Simple Solutions)

Aug 6, 2024

Here's a sample dataset with sparklines that we'll troubleshoot. Sparklines Are Not Showing in Excel: 6 Simple Solutions We'll use the ...