Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

VBA in Excel

How to Use Short Date Number Format in Excel

Excel is a powerful tool for working with data, and one of the most common tasks is working with dates. In Excel, dates can be entered in a variety ...

How to Calculate Upper and Lower Limits in Excel (2 Methods)

Every now and then, there comes a situation where we need to know the upper and lower limits of a large dataset. This is one of the situations where ...

How to Perform Drawing of Objects with VBA in Excel (2 Examples)

Sometimes you may need to draw a shape or an object in Excel. So, if you are looking for drawing objects using VBA code in Excel, then you have come ...

How to Truncate Text from Left in Excel (5 Suitable Ways)

When you have a big dataset with text as cell values, then you may need to shorten the text in Excel. Basically, you can truncate a text either from ...

How to Use REGEX to Match Patterns in Excel (6 Examples)

If you are trying to find a match with any REGEX pattern to your dataset in Excel, then this article may help you. A REGEX pattern is basically a ...

Excel Chart Disappears When Data Is Hidden (3 Solutions)

Sometimes for data visualization, you may need to use an Excel chart. But when you hide your data, your chart may disappear. So, if you find the ...

[Fixed!] Border Not Showing in Excel (6 Solutions)

Sometimes you may need to print out your data or Excel spreadsheets. In that case, if there are Borders then it will be easy to read the data. But ...

How to Reverse Rows in Excel (4 Easy Ways)

Surprisingly, you may not find any inbuilt option to reverse a set of data in rows in Excel. It needs to be done manually. These are all the methods ...

How to Open Workbook from Path Using Excel VBA (4 Examples)

With Excel VBA you can directly open a workbook from a path. In this article, I will demonstrate how to open a workbook from a path using Excel VBA. ...

Excel VBA to Populate Array with Cell Values (4 Suitable Examples)

Sometimes, you may need to populate an Array with cell values in Excel VBA. Thus, I will explain how to populate an Array with cell values in Excel ...

How to Alternate Row Colors in Excel Without Table (5 Methods)

For the purpose of attracting your data, you can alternate Row colors in Excel without even making a Table. In this article, I will explain how to ...

How to Hide Unused Columns in Excel (5 Quick Tricks)

There are so many built-in Columns in Excel. Most of the time, you don't need to use all those Columns. In such cases, you may hide unused Columns in ...

How to Put Comma After 2 Digits in Excel (9 Quick Methods)

When you want to keep data with many digits then you may need to put Comma after 2 digits for easier understandability in Excel. In this article, I ...

How to Capitalize First Letter of Sentence in Excel (6 Suitable Methods)

Excel is not only for numerical values but also you may need to work with text data. So, if you know how to capitalize the first letter of a sentence ...

How to Make VBA Code Run Faster (15 Suitable Ways)

A Visual Basic Applications (VBA) user knows about the importance of why to make VBA code run faster. In this article, I have explained how to make ...

ExcelDemy
Logo