Macros & Excel VBA

How to Count Visible Rows in Excel (3 Suitable Methods)

While dealing with a large dataset, adding many rows to your worksheet is necessary. But at the same time, you may need to hide some rows to give the ...

How to Count Date Occurrences in Excel (3 Suitable Examples)

This article will focus on how to count date occurrences in Excel from different datasets and different conditions. Download Practice Workbook ...

How to Find Unique Values from Multiple Columns in Excel

In this article, I will be showing how you can find unique values from multiple columns in Microsoft Excel. Download Practice Workbook ...

How to Separate Text and Numbers in Excel (6 Suitable Ways)

We often have to separate text and numbers from some data in Excel. Today I will be showing 4 easy ways how you can accomplish that conveniently. ...

Excel Formula to Copy Cell Value to Another Cell

Copying might be a monotonous phase while using Excel. Using formulas can bring some life to this copy task. The agenda for today’s tutorial is how ...

How to Copy Formula Down Without Incrementing in Excel

While working in Excel, we often have to copy down one formula to another group of cells without incrementing. Today I will be showing three easy ...

How to Convert Number to Words in Excel (4 Suitable Ways)

Spreadsheets are used by many people in their daily jobs, making them an important element of their office. While the majority of people use ...

Copy Rows from One Sheet to Another Based on Criteria in Excel

In Microsoft Excel sometimes we need to copy rows from any worksheet to another worksheet based on different criteria. In this article, I will show ...

How to Make All Cells the Same Size in Excel (5 Easy Ways)

Are you looking for methods to resize the multiple cells in an Excel spreadsheet? In Microsoft Excel, most of the time we need to resize the shapes ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

The article will show you how to insert the square root symbol in Excel. Sometimes you may need to store irrational numbers as data in an Excel ...

How to Copy a Worksheet in Excel (4 Smart Ways)

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

How to Auto Populate Date in Excel When Cell Is Updated

Sometimes, several people work on a worksheet and anyone can update the worksheet anytime. So, the worksheet owner might want to see the last updates ...

How to Convert Text to Numbers in Excel (8 Easy Ways)

Sometimes the numbers on your worksheet behave strangely; they don't carry out arithmetic operations as they ought to. This is because, despite their ...

How to Highlight Every Other Row in Excel (3 Easy Methods)

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

How to Generate Random Numbers in Excel (4 Unique Methods)

Random numbers are those numbers that are generated by a process in which the outcome is not predictable and in a defined interval/set, the values ...

ExcelDemy
Logo