Excel Basics Archives - Page 103 of 124

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)

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

Excel Table Formatting Problems (with Solutions)

How to Add a Row to the Bottom of a Table Using an Excel Macro (2 Methods)

Jul 16, 2024

Dataset Overview In this article, we’ve got a table named Table1 in an Excel worksheet that contains the names, starting salaries, and present ...

How to Add a Row to the Bottom of a Table Using an Excel Macro (2 Methods)

How to get Excel to Recognize Numbers in Cells (3 Techniques)

Jun 17, 2024

Below is a dataset with some formatted numbers. Method 1 – Using the Number Format Command Steps: Select the range of cells B5:B10. ...

How to get Excel to Recognize Numbers in Cells (3 Techniques)

How to Name a Group of Cells in Excel (3 Easy Methods)

Jul 5, 2024

Although naming ranges of cells is one of the most useful features in Excel, making formulas more readable, easy to understand, and maintainable, it ...

How to Name a Group of Cells in Excel (3 Easy Methods)

How to Highlight Row If Cell Contains Any Text in Excel

Jun 15, 2024

Here's a GIF overview of using conditional formatting to highlight rows based on certain values inside them. How to Highlight Row If the ...

How to Highlight Row If Cell Contains Any Text in Excel

How to Edit Defined Names in Excel: 2 Methods

Jul 5, 2024

Step 1 - Opening the Name Manager Window in Excel Go to the Formulas tab. Click on Name Manager from the Defined Names group. The Name ...

How to Edit Defined Names in Excel: 2 Methods

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

Jun 14, 2024

Method 1 - Using Find and Replace Step 1: Go to Home Tab > Select Find & Select (in Editing section) > Click on Replace (from the ...

How to Remove Hidden Double Quotes in Excel: 6 Easy Ways

How to Remove Error in Excel: 8 Methods

Jul 7, 2024

Method 1 - Using Go To Special to Remove Error Remove errors; use the Go To Special. Open the Home tab >> go to Editing group >> from ...