Excel Basics Archives - Page 124 of 176

Formula to Return Blank Cell instead of Zero in Excel (with 5 Alternatives)

Jun 18, 2024

The easiest way to to return a blank cell instead of zero in Excel is to use a formula. In this article we'll demonstrate and explain that formula, ...

Formula to Return Blank Cell instead of Zero in Excel (with 5 Alternatives)

How to Copy Exact Formula in Excel (13 Methods)

Nov 11, 2025

Copy and Paste is one of the commonly performed activities while working with Microsoft Excel. We can copy any text, formula, or format in Excel. ...

How to Copy Exact Formula in Excel (13 Methods)

Delete Sheet Not Working in Excel (2 Solutions)

Jul 27, 2024

Solution 1 - Unprotect Workbook Structure While Delete Sheet in Excel is Not Working Overview If you’re unable to delete a sheet in Microsoft ...

Delete Sheet Not Working in Excel (2 Solutions)

How to Select a Range of Cells in Excel (9 Methods)

Apr 20, 2024

We will use the following dataset to illustrate selecting cells. Method 1 - Click & Drag to Select a Range of Cells in Excel For ...

How to Select a Range of Cells in Excel (9 Methods)

How to Change Cell Size in Excel (5 Easy Ways)

Aug 4, 2024

In this article we will explain five methods to change cell size in Excel. To demonstrate the methods, we'll use the following sample dataset ...

How to Change Cell Size in Excel (5 Easy Ways)

Difference Between Paste and Paste Special in Excel

Nov 11, 2025

The Paste command in Excel is an operation command that inserts data from the clipboard that you’ve already stored by copying the data from somewhere ...

Difference Between Paste and Paste Special in Excel

How to Reset Cell Size to Default in Excel (5 Easy Ways)

Nov 11, 2025

In this article, we will learn to reset cell size to default in Excel. A cell has a rectangular shape that has a width and a height. We can change ...

How to Reset Cell Size to Default in Excel (5 Easy Ways)

How to Add Text after Number with Custom Format in Excel (4 Easy Methods)

Jun 18, 2024

In the following dataset are the Order Time, Weight, Sales, and Profit/Loss of some products, with data in a variety of numeric formats. In this ...

How to Add Text after Number with Custom Format in Excel (4 Easy Methods)

How to Create a Formula in Excel without Using a Function (6 Approaches)

Nov 11, 2025

Excel is one of the most useful tools we are familiar with. It enables us to perform myriads of calculations applying the functions available in ...

How to Create a Formula in Excel without Using a Function (6 Approaches)

How to Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

Jun 16, 2024

In the dataset below, the Sales Report for January is provided, and some cells are blank. Method 1 – Using a Simple Formula Steps: ...

How to Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

How to Delete Multiple Rows in Excel Using Formula?

Jul 29, 2024

We will be applying 5 methods to remove rows. We'll use a sample dataset with four columns, Car Name, Company Name, Price, and Max Speed (Mph). ...

How to Delete Multiple Rows in Excel Using Formula?

How to Fix #REF! Error in Excel (6 Solutions)

Jul 12, 2024

Understanding the #REF! Error in Excel The #REF! error occurs when a cell reference becomes invalid or nonexistent. Here are the common scenarios ...

How to Fix #REF! Error in Excel (6 Solutions)

How to Use Flash Fill in Excel to Split Data (4 Quick Ways)

Nov 11, 2025

In this article, we will learn how to use Flash Fill in Excel to Split Data. There are several ways to Split data into several columns in Excel like ...

How to Use Flash Fill in Excel to Split Data (4 Quick Ways)

How to Copy Alternate Rows in Excel (4 Ways)

Jun 19, 2024

We'll use the following sample dataset to copy alternate rows from it. Method 1 - Hold the Ctrl Key and Select to Copy Alternate Rows in Excel ...

How to Copy Alternate Rows in Excel (4 Ways)

[Fixed] Excel Print Error Not Enough Memory

Jun 18, 2024

You might receive the error message below when trying to print an Excel file (.xlsx or .xlsm). There are several possible reasons for this error, ...