Latest Blog Posts - Page 443 of 587

How to Lock Multiple Cells in Excel – 6 Methods

Aug 14, 2024

This is the sample dataset. Method 1 - Using the Format Cells Option Step 1 - Removing the Default "Locked" Option Place ...

How to Lock Multiple Cells in Excel – 6 Methods

How to Combine Two Line Graphs in Excel – 3 Methods

Aug 10, 2024

How to Combine Two Line Graphs in Excel This is the sample dataset. To show Alex and John's sales over the six months: Method 1 - Use ...

How to Combine Two Line Graphs in Excel – 3 Methods

Excel Checkbox: If Checked then Change Cell Color (2 Methods)

Jul 3, 2024

How to Insert Checkboxes in Excel Method 1 - Insert a Single Checkbox Steps Go to the Developer tab in the ribbon. If you don’t see the tab, ...

Excel Checkbox: If Checked then Change Cell Color (2 Methods)

How to Count Repeated Words in Excel (11 Methods)

Jun 14, 2024

We have a dataset of some people with their favorite fruits. We are going to use this as the sample dataset all through the article. ...

How to Count Repeated Words in Excel (11 Methods)

How to AutoFill Sequential Letters in Excel (5 Quick Ways)

Jul 4, 2024

In this article, we will demonstrate how to AutoFill sequential letters in Excel (A, B, C, D, etc.). We'll use the following dataset where a Gate No ...

How to AutoFill Sequential Letters in Excel (5 Quick Ways)

Excel VBA: Turn Off the “On Error Resume Next”

Jul 7, 2024

In this tutorial, we will demonstrate the most effective way to turn off On Error Resume Next in Excel VBA. The On Error Statement in VBA ...

Excel VBA: Turn Off the “On Error Resume Next”

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

Jun 16, 2024

How to Use Code in the Visual Basic Editor Go to the Developer tab from the Excel ribbon. Click on the Visual Basic option. In the ...

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

How to Auto Number Cells in Excel (10 Methods)

Jun 14, 2024

We will be using the following dataset to show how to auto-number cells. Method 1 - Using the Fill Handle to Auto Number Cells in Excel ...

How to Auto Number Cells in Excel (10 Methods)

How to Copy a Formula Across Multiple Rows in Excel (7 Methods)

May 6, 2024

The sample dataset contains some items and the quantity of those items. The item's quantity increased 5 times in every month. Instead of retyping ...

How to Copy a Formula Across Multiple Rows in Excel (7 Methods)

[Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel

Jul 5, 2024

We used a simple subtraction formula to get the difference between time data. The formula we have used is: =C5-B5 Reason 1 - Excel ...

[Fixed!] VALUE Error (#VALUE!) When Subtracting Time in Excel

How to Change Font Size of the Whole Sheet with Excel VBA

Nov 11, 2025

In this article, I’ll show you how you can change the font size of a whole sheet with VBA in Excel. While working in Excel, we sometimes need to ...

How to Change Font Size of the Whole Sheet with Excel VBA

How to Reference Cell by Row and Column Number in Excel (4 Methods)

Apr 30, 2024

This article will show you four ways to reference a cell by row and column number in Excel with sharp steps and vivid illustrations. In the following ...

How to Reference Cell by Row and Column Number in Excel (4 Methods)

How to Use Advanced Filter for Unique Records Only in Excel

Jul 12, 2024

We have a dataset that contains multiple identical entries. We want to remove identical entries and keep one of them. Use an Advanced ...

How to Use Advanced Filter for Unique Records Only in Excel

How to Count the Order of Occurrence of Duplicates in Excel (4 Methods)

Jul 21, 2024

Method 1 - Use COUNTIF Function This method allows you to count the order of occurrence of any type of values in Excel cells, such as text or ...

How to Count the Order of Occurrence of Duplicates in Excel (4 Methods)

How to Use Advanced Filter to Copy Data to Another Sheet in Excel

Jul 28, 2024

In this article, we will demonstrate two methods to apply the Advanced Filter to copy data to another sheet in Excel. In the first method, we will ...