Excel Basics Archives

How to Format Text Using Excel VBA (12 Methods)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 15, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 12, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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)

Jan 13, 2022 Excel Basics

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