Excel Basics

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

We always change cell size in Excel. There is more than one way to do this task. We have explained five methods of how to change cell size in Excel. ...

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

If you are looking for some of the easiest ways to add text after number with custom format in Excel, then you are in the right place. So, let’s ...

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

Perhaps you may have a larger dataset with numerous blank cells. Using a popular highlighting tool i.e. Conditional Formatting, you are easily able ...

How to Delete Multiple Rows in Excel Using Formula?

This article gives a brief description of how to delete multiple rows in Excel using formulas. There are several different ways to eliminate rows by ...

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

While working in Excel, facing the #REF! error is one of the most common errors. But no worries, we are here to rescue you from those errors. This ...

How to Copy Alternate Rows in Excel (4 Ways)

While dealing with huge data analysis, you may need to copy multiple alternate rows and paste them someplace at the same time. Excel does not have a ...

[Fixed] Excel Print Error Not Enough Memory

Sometimes you may get troubled while printing any large Excel datasets or charts. But you can fix this issue using some handy methods. Prior to ...

Filling a Certain Number of Rows in Excel Automatically (6 Methods)

We need to Fill a certain number of rows now and then in Excel. The task can be tiresome if we want to do it manually. Luckily Microsoft Excel ...

How to Write 001 in Excel (11 Effective Methods)

Excel automatically removes the leading zeros from a number when you enter it in a  cell. Therefore, you cannot directly write 001 in Excel and ...

How to Copy Formula and Paste as Text in Excel (2 Ways)

Excel has no built-in function to directly copy a formula and later paste it as text. Whatever you paste in Excel cells, if it resembles a formula ...

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

If you are looking for some of the easiest ways to ignore blank cells in a range in Excel to get perfect results with formulas, then you will find ...

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

When performing calculations in Excel, sometimes we want the results to be displayed as a blank cell if the computation does not meet our needs. When ...

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

Most of the time, in Excel, when we copy data from one workbook and paste it into another workbook, it is expected that data will be copied along ...

How to Delete Infinite Columns in Excel (4 Methods)

Actually, Excel doesn’t have infinite columns. Excel 2007 and all the newer versions have 16384 columns in total. The number is so huge for most of ...

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

Instead of deleting rows one by one, it will be helpful if we can delete multiple rows at once. In this article, I will try to show you the process ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo