Excel Basics

How to Format Text Using Excel VBA (12 Methods)

In this article, we’ll illustrate how to change the format of a text in Excel using VBA code. While working with a large amount of information, ...

Cell Reference in Excel VBA (8 Ways)

In this article, I’ll show you how you can access a cell reference in VBA in Excel. You’ll learn to access a single cell, as well as multiple cells ...

How to Apply AutoFill Shortcut in Excel (7 Methods)

This tutorial will help you to use Autofill shortcut in Excel of various types to conveniently autofill or populate the cells in Excel without any ...

How to Use Excel Cell Format Formula (4 Effective Methods)

In some cases, we need to convert or adjust or transform the data cell in a specific format without changing the originality. In this article, I’ll ...

How to Add Minutes to Time in Excel (3 Quick Methods)

We often use time in our worksheets for business purposes, educational purposes, and many others. In some cases, we need to add or subtract time in ...

How to Delete Extra Columns in Excel (7 Methods)

While working with Microsoft Excel, sometimes we need to delete extra columns in Excel. Microsoft Excel can easily delete extra columns by using ...

[Fixed!] SUM Not Working with Time Values in Excel (5 Solutions)

Microsoft Excel is one of the most popular applications used in big corporates and business centers. It contains lots of built-in functions that help ...

Formula to Remove Blank Rows in Excel (5 Examples)

Having blank rows in a Microsoft Excel worksheet is a common scenario. Most of them are unnecessary and they consume more spaces that increase the ...

Excel Shortcut to Delete Rows (With Bonus Techniques)

While working with Microsoft Excel, you will face a lot of situations where you need to delete rows. Now, some people love to work with the mouse and ...

How to Use Format Painter Shortcut in Excel (5 Ways)

If you are looking for some of the easiest ways to use the Format Painter shortcut in Excel, then you will find this article useful. Format Painter ...

How to Hide Duplicates in Excel (4 Ways)

While working in Excel, you may have duplicate values in your dataset. For any reason, if you need to hide those duplicate values or rows then you ...

How to Delete Hidden Rows in Excel (3 Methods)

Sometimes while working in Microsoft Excel, we may have to deal with a lot of hidden rows or columns. Hidden data may be unavailable as well as ...

Absolute Cell Reference in Excel (4 Examples)

In this article, we will let you know what Absolute Cell Reference in Excel is and describe it with 4 useful examples. Download Workbook You ...

How to Delete Duplicate Columns in Excel (6 Ways)

Microsoft Excel is an extensively used program, but when it comes to deleting and eliminating duplicate data, it can be a bit complicated. When ...

How to Calculate Time in Excel (16 Possible Ways)

It is possible to calculate time using arithmetic operations along with excel functions because in Excel dates and times are stored as numbers in the ...

ExcelDemy
Logo