Excel Basics Archives - Page 4 of 15

How to Combine Rows into One Cell in Excel

Oct 11, 2021 Excel Basics

Today I will be showing how to combine rows into one cell in Excel. While working in Excel, trying to combine rows or columns is one of the most ...

How to Concatenate with Space in Excel (3 Suitable Ways)

Oct 11, 2021 Excel Basics

One of the most important features of Excel is to concatenate, that is to collect and maintain data from various places in a worksheet. Today I will ...

How to Use Autofill Formula in Excel (6 Ways)

Oct 4, 2021 Excel Basics

While working with Excel worksheets you may have to use formulas for your data and you may wish to repeat the results in other cells. This can be ...

How to Concatenate Range in Excel (For Both Old and New Versions)

Oct 11, 2021 Excel Basics

One of the most important features of Excel is to concatenate the values from all the cells of a range into a single cell. Today I will be showing ...

How to Perform Predictive Autofill in Excel (5 Methods)

Oct 3, 2021 Excel Basics

The Predictive Autofill feature in Excel can save you time when you are entering lots of similar information in a column. Excel includes some handy ...

How to Concatenate in Excel (3 Suitable Ways)

Oct 11, 2021 Excel Basics

One of the most important features of Excel is to collect and contain data from various places into a single cell. In other words, to concatenate. ...

How to Add Numbers in Excel (2 Easy Ways)

Oct 11, 2021 Excel Basics

While working in Excel, we often are to add numbers for various purposes. Today I will be showing how to add numbers in Excel. How to Add ...

How to Number Rows in Excel (9 Simple Methods)

Oct 3, 2021 Excel Basics

In Excel, you may come across repetitive tasks often. Numbering rows is one of these tasks which can be a time-consuming one. There are several ways ...

How to Create Drop Down List in Multiple Columns in Excel (3 Ways)

Sep 30, 2021 Excel Basics

When you are working with a large database and you need to pick a specific item from a list, a drop-down list can help you in this situation. Using a ...

Auto Update Drop Down List in Excel (3 Ways)

Sep 30, 2021 Excel Basics 1

In MS Excel, we usually create a drop-down list for some daily work. By default, we can add new data in a cell among the range of original data, then ...

How to Autocomplete Cells or Columns From List in Excel

Sep 29, 2021 Excel Basics

Every time we do a monotonous task, we may wish we could have done things differently. Excel provides us various features to complete from a list ...

How to Add 7 Days to a Date in Excel (3 Methods)

Oct 3, 2021 Excel Basics

To keep timely records of your work, you need to add dates to your worksheet. If you manually add your date sometimes this process becomes very ...

How to Create Dependent Drop Down List in Excel

Oct 11, 2021 Excel Basics

Up till now, we have learned to create drop-down lists in Excel. Today I will be showing how you to create a dependent drop down list in Excel. ...

How to Autofill Numbers in Excel (12 Ways)

Sep 29, 2021 Excel Basics

There are several short and quick methods to autofill numbers in Microsoft Excel. In this article, you’ll learn how you can easily apply those useful ...

How to Insert Date in Excel (7 Simple Methods)

Oct 10, 2021 Excel Basics

There are several purposes for inserting dates in excel; tracking any information or for any date-time calculation you need to insert dates. Today we ...