Excel Basics Archives - Page 124 of 176

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

[Fixed] Excel Print Error Not Enough Memory

Filling a Certain Number of Rows in Excel Automatically: 6 Methods

May 25, 2024

Method 1 - Making Pattern and Using Fill Handle for Filling a Certain Number of Excel Rows Make a pattern of numbers. Fill Handle will allow us to ...

Filling a Certain Number of Rows in Excel Automatically: 6 Methods

How to Write 001 in Excel (11 Effective Methods)

May 29, 2024

Excel automatically removes the leading zeros from a number when entered in a cell, making it impossible to write 001. Below, learn 11 possible ways ...

How to Write 001 in Excel (11 Effective Methods)

How to Copy a Formula and Paste it as Text in Excel – 2 Methods

Aug 9, 2024

Method 1 - Use the Text Import Wizard and the Notepad to Copy a Formula and Paste it as Text in Excel 1.1 Display Cell Formulas The image below ...