Excel Basics

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

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 Add Text after Number with Custom Format in Excel (4 Easy Methods)

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 Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

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 Delete Multiple Rows in Excel Using Formula?

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 Fix #REF! Error in Excel (6 Solutions)

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 Copy Alternate Rows in Excel (4 Ways)

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

[Fixed] Excel Print Error Not Enough Memory

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

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

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

How to Write 001 in Excel (11 Effective Methods)

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 Copy a Formula and Paste it as Text in Excel – 2 Methods

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

How to Ignore Blank Cells in Range in Excel (8 Ways)

  Consider the following dataset containing the Selling Price and Cost Price of some products of a company. We will use it to demonstrate how ...

How to Set Cell to Blank in Formula in Excel (6 Ways)

We'll use the example dataset, which includes information on Region, Product, Quantity Price, and Sales. There are some blank cells in the Quantity ...

How to Copy and Paste Formulas from One Workbook to Another in Excel

  Method 1 – Using the Paste Option to Copy Formulas from One Workbook And Paste to Another Steps: Go to Book1 and copy the data (E5:E10) ...

How to Delete Infinite Columns in Excel (4 Methods)

Excel 2007 and all the newer versions have 16384 columns in total. When you are working with a smaller dataset, these huge numbers of unused columns ...

How to Delete Multiple Rows in Excel at Once (5 Easy Ways)

The dataset below, Sales of "ABC" Company, shows sales information for products on various dates. It has four columns: Order ID, Product, Amount, and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo