Excel Basics Archives - Page 150 of 176

How to Apply Conditional Formatting to Each Row Individually

Nov 11, 2025

Conditional Formatting is a versatile feature embedded in Excel, that comes up with a lot of flexibility in terms of highlighting cells. You can ...

How to Apply Conditional Formatting to Each Row Individually

How to Return Value If Cell Is Blank (12 Ways)

Jun 15, 2024

Consider the following overview of checking if the cell is blank, where the status is updated based on the delivery date. We are using the ...

How to Return Value If Cell Is Blank (12 Ways)

Change Font Color Based on Value of Another Cell in Excel

Jul 9, 2024

In this tutorial, we will demonstrate how to change font color based on the value of another cell. Here is an overview of the process. To ...

Change Font Color Based on Value of Another Cell in Excel

How to Add Leading Apostrophe In Excel (4 Ways)

Jan 25, 2024

Excel may treat certain entries, particularly numbers that start with zeros, as formulas or numeric data. By adding a leading apostrophe to a cell ...

How to Add Leading Apostrophe In Excel (4 Ways)

How to Perform Data Validation for Alphanumeric Only in Excel

Jul 5, 2024

Method 1 - Using a Custom Formula to Data Validate Any Alphanumeric STEPS: Use the following formula in the C5 cell. ...

How to Perform Data Validation for Alphanumeric Only in Excel

How to Concatenate Range with Separator Using VBA in Excel

Nov 11, 2025

In this article, we’ll show you how you can concatenate a range of cells with a given separator using VBA in Excel. You’ll learn to concatenate the ...

How to Concatenate Range with Separator Using VBA in Excel

How to Highlight Row If Cell Is Not Blank

Jul 4, 2024

We have an Employee Dataset containing employee names, departments, designations, hiring dates, and annual salaries. In this dataset, we will ...

How to Highlight Row If Cell Is Not Blank

Conditional Formatting Entire Column Based on Another Column in Excel

May 14, 2024

In Excel, conditional formatting is used to highlight any cells based on predetermined criteria and the value of those cells. We can also apply ...

Conditional Formatting Entire Column Based on Another Column in Excel

How to Remove Scientific Notation in Excel (4 Quick Ways)

Jul 5, 2024

What is Scientific Notation? Scientific notation is a special way of writing very small and very large numbers using a shorthand method. Read ...

How to Remove Scientific Notation in Excel (4 Quick Ways)

How to Convert Scientific Notation to Text in Excel – 6 Methods

Jul 31, 2024

This is an overview: The following dataset contains 5 numbers of more than 11 digits. By default, Excel converts them into Scientific ...

How to Convert Scientific Notation to Text in Excel – 6 Methods

How to Paste Range Names in Excel (7 Ways)

Jul 13, 2024

In this article we will demonstrate some of useful ways to paste range names in Excel. Pasting range names can simplify working in Excel, ...

How to Paste Range Names in Excel (7 Ways)

How to Find and Count Non-Blank Cells – 4 Methods

Aug 15, 2024

This is the sample dataset. Method 1 - Using the IF Function to Determine If a Cell Is Not Blank To see ‘Done’ in non-blank cells and ...

How to Find and Count Non-Blank Cells – 4 Methods

How to Highlight Cells in Excel Based on Value (9 Methods)

Jun 14, 2024

Let’s say we have a dataset where sales area and Number of units sold in different months of the first quarter by different salesmen are given. Now ...

How to Highlight Cells in Excel Based on Value (9 Methods)

[Fixed!] VALUE Error in Excel (8 Reasons with Solutions)

Nov 11, 2025

Excel is a powerful tool for data analysis and manipulation, but it can be frustrating when errors occur in your formulas or functions. One of the ...

[Fixed!] VALUE Error in Excel (8 Reasons with Solutions)

Excel Table Formatting Problems (with Solutions)

Jul 16, 2024

In this article, we will discuss table formatting problems in Excel. We'll use a simple dataset to show solutions. Excel Table Formatting ...