VBA in Excel Archives

How to Use Short Date Number Format in Excel

May 9, 2023

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 Use Short Date Number Format in Excel

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

May 10, 2023

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 Calculate Upper and Lower Limits in Excel (2 Methods)

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

Apr 25, 2023

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 Perform Drawing of Objects with VBA in Excel (2 Examples)

How to Create a Calculator Using Macros in Excel (with Easy Steps)

May 25, 2023

You could be a businessman, a student, or anything else. Every day, you require a simple calculator. Although Excel itself is a complete calculator, ...

How to Create a Calculator Using Macros in Excel (with Easy Steps)

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

Apr 30, 2023

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 Truncate Text from Left in Excel (5 Suitable Ways)

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

Apr 27, 2023

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

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

Excel Chart Disappears When Data Is Hidden (3 Solutions)

May 11, 2023

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

Excel Chart Disappears When Data Is Hidden (3 Solutions)

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

Jan 24, 2023

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

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

How to Reverse Rows in Excel (4 Easy Ways)

Feb 8, 2023

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 Reverse Rows in Excel (4 Easy Ways)

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

Feb 27, 2023

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

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

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

Feb 13, 2023

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

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

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

Jan 23, 2023

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 Alternate Row Colors in Excel Without Table (5 Methods)

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

Mar 14, 2023

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 Hide Unused Columns in Excel (5 Quick Tricks)

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

Feb 9, 2023

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 Put Comma After 2 Digits in Excel (9 Quick Methods)

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

Apr 6, 2023

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