Excel Basics Archives - Page 137 of 168

Mixed Cell Reference in Excel (4 Examples)

Sep 21, 2023

In this article, we will let you know what mixed cell reference is in Excel and describe it with 4 examples. What is Mixed Cell Reference in ...

Mixed Cell Reference in Excel (4 Examples)

How to Use VBA to Remove Duplicates in Excel (6 Examples)

Oct 3, 2023

Sometimes you want to remove duplicate values from your worksheet to work only with the unique values. In Excel, you can remove duplicates very ...

How to Use VBA to Remove Duplicates in Excel (6 Examples)

Excel Shortcut to Merge Cells (3 Methods + Bonus)

Apr 6, 2023

In Microsoft Excel, merging cells is one of those essential tasks. To prepare a great presentation, you may need to merge some cells of your dataset. ...

Excel Shortcut to Merge Cells (3 Methods + Bonus)

How to Format Text Using Excel VBA (12 Methods)

Sep 18, 2023

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

How to Format Text Using Excel VBA (12 Methods)

Cell Reference in Excel VBA (8 Examples)

May 2, 2023

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

Cell Reference in Excel VBA (8 Examples)

How to Apply AutoFill Shortcut in Excel (7 Methods)

Oct 3, 2023

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 Apply AutoFill Shortcut in Excel (7 Methods)

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

Sep 18, 2023

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 Use Excel Cell Format Formula (4 Effective Methods)

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

Oct 2, 2023

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

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

How to Delete Rows Using Excel Shortcuts?

Oct 2, 2023

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

How to Delete Rows Using Excel Shortcuts?

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

Sep 19, 2023

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 Use Format Painter Shortcut in Excel (5 Ways)

How to Hide Duplicates in Excel (4 Ways)

Sep 25, 2023

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 Hide Duplicates in Excel (4 Ways)

How to Delete Hidden Rows in Excel?

Sep 21, 2023

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

Example with Absolute Cell Reference in Excel (4 Apllications)

Feb 6, 2023

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

Example with Absolute Cell Reference in Excel (4 Apllications)

How to Calculate Time in Excel (17 Possible Ways)

Sep 13, 2023

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

How to Calculate Time in Excel (17 Possible Ways)

Timesheet Formula in Excel (5 Examples)

Feb 8, 2023

To calculate the time difference (e.g. work hours) between two time periods, we create a timesheet. There are several ways that we can use to keep ...