Macros & Excel VBA

3 Quick Ways to Copy Down Excel Formula without Incrementing

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 Numbers to Texts/Words in Excel

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

Excel Copy Rows from One Sheet to Another Based on Criteria (5 Ways)

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

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

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

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 (5 Smart Ways)

In Excel, there are many ways to copy a worksheet in the same or different workbook. In this article, we will see many processes on how to copy a ...

How to auto populate date in Excel when cell is updated

In this article, I will show you how to auto-populate date in Excel when a cell is updated. I will show the whole process using Excel VBA. I will ...

How to Convert Text to Numbers in Excel

In this article, I tried to sum up some of the processes on how to convert text to numbers in Excel. In many cases when you import data from an ...

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

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

How to Use For Each Loop in Excel VBA (3 Suitable Examples)

A For Each Loop is a piece of code that handles repetitive tasks efficiently without using any repetitive coding blocks. In this article, we ...

How to Use Do While Loop in Excel VBA (3 Examples)

When you would like to repeat a statement as long as the condition meets, you can use the do while loop in Excel VBA. Using the do while loop, you ...

How to Use Do Until Loop in Excel VBA (with 2 Examples)

People like to be adventurous. They do not like to do the same thing again, again and again. In terms of working with VBA, we can skip the same code ...

Changing Case using Worksheet Functions and Excel VBA

Excel provides the text worksheet functions, namely the Upper Function, the Lower Function, and the Proper Function, which can change the case of a ...

ExcelDemy
Logo