ExcelDemy - Page 80 of 240 - Free Excel Tutorial & Online Courses

How to Add a Checkbox in Excel (2 Steps + 4 Uses)

May 25, 2022 Excel Basics

Most likely you see a checkbox that is mainly used for selecting or deselecting any option. Though the process of adding a checkbox in Excel is quite ...

How to Increase Cell Size in Excel (7 Methods)

Mar 27, 2022 Excel Basics 4

In this article, we will get to know several methods of how to increase Cell size in MS Excel. When we create a new Excel workbook, the Row Height ...

Calculate Years and Months between Two Dates in Excel (6 Approaches)

May 25, 2022 Excel Formulas

All of our everyday tasks depend on time. We must keep track of time because time is a transient circumstance. Years, months, days, etc. are used to ...

How to Make Cells Independent in Excel (5 Methods)

Mar 27, 2022 Excel Basics

Resizing the cells in Excel to make them independent from other cells is an essential thing to do when it comes to putting a larger word or number in ...

Combine Multiple Excel Files into One Workbook with Separate Sheets

Mar 27, 2022 Excel Basics

Often, we have to deal with multiple Excel files, which is inconvenient. Things get easier if we can combine those Excel files into a single ...

How to Find Blank Cells in Excel (8 Easy Ways)

May 25, 2022 Excel Formulas

This tutorial shows how to find blank cells in excel. Sometimes we receive excel files from someone or import that file from a database. To work ...

How to Copy Conditional Formatting to Another Cell in Excel (2 Methods)

Mar 30, 2022 Excel Formulas

If you use specific conditional formatting to highlight cells based on some specific conditions, you might want to copy the conditional formatting to ...

How to Unlock Cells without Password in Excel (4 Methods)

Mar 16, 2022 Excel Basics

This article illustrates how to unlock cells in Excel without a password with 4 different methods. Excel allows the feature to lock cells with ...

How to Skip Blank Rows Using Formula in Excel (8 Methods)

May 25, 2022 Excel Formulas

A Microsoft Excel spreadsheet with blank rows is a frequent occurrence. The majority of them are superfluous, and they take up extra space on the ...

How to Move Cells Up in Excel (3 Easy Ways)

Mar 15, 2022 Excel Basics

Sometimes we face the necessity to move the cells up. Here, I will try to show how to Move cells Up in Excel to overcome our cells moving problem. ...

VBA to Count Blank Cells in Range in Excel (3 Methods)

Mar 28, 2022 Macros & Excel VBA

When we have a large amount of data in our Excel worksheet, it is easier if we have the knowledge of the total counts of certain ranges of the sheet. ...

VBA to Copy Data to Another Sheet with Advanced Filter in Excel

Mar 24, 2022 Advanced Excel

When we are dealing with multiple Excel sheets, sometimes we have to copy data from one spreadsheet to another with certain conditions for better ...

How to Combine Graphs with Different X Axis in Excel

Mar 15, 2022 Advanced Excel

In Microsoft Excel, plotting graphs in worksheets is one of the crucial tasks. Graphs make a worksheet visually attractive to the user. Mainly, ...

How to Create an Excel Formula to Subtract (10 Examples)

Apr 12, 2022 Excel Basics

Subtraction is a common operation in mathematics. In Microsoft Excel, we don't have any built-in function for subtraction. We will show how to create ...

Excel VBA: Delete Files with Wildcards (4 Methods)

Mar 27, 2022 Macros & Excel VBA

VBA allows us to delete any file on the computer by utilizing VBA programs. Using simple VBA programs, we may delete any individual file, specified ...

Latest Posts