Excel Basics

How to Edit Links in Excel (3 Methods)

While working with a large database we sometimes may need to link other workbooks to the database to get data. But in many situations, the link can ...

How to Hyperlink to Cell in Excel (2 Simple Methods)

Situations may demand you to deal with links in Excel. Cases can be like find links, deal broken links, and many more. Today we are going to show you ...

Find Broken Links in Excel (4 Quick Methods)

While working with Microsoft Excel, it’s a common scenario to find some broken links in the data. There are a few simple reasons behind this problem ...

How to Enter Time in Excel (5 Methods)

Entering time manually is one of the most boring things to do in Excel. Luckily, Excel has some features by which you can easily input time value in ...

Find And Replace Multiple Values in Excel (6 Quick Methods)

In Microsoft Excel, it’s a usual scenario to find and replace multiple text or numeric values. You can use the Find and Replace command, apply ...

How to Create List from Range in Excel (3 Methods)

While working with a large database, you may need to create a list of data or text from the given database. If you do it manually, it will cost you a ...

How to Find And Replace Values Using Wildcards in Excel

While dealing with data in Excel you may need to eradicate errors or modify your data regularly. Removing errors or regular modification, on both ...

Find External Links in Excel (6 Quick Methods)

While working with Microsoft Excel, it’s a common scenario to look for external links and references in the active workbook. In this article, you’ll ...

How to Copy the Same Value in Multiple Cells in Excel (4 Methods)

Copying cell values in multiple cells and pasting them is one of the easiest jobs in Microsoft Excel. You can copy single or multiple cells and then ...

How to Number Columns in Excel Automatically (5 Easy Ways)

While working in Excel, we often have to number our rows and columns for quick glancing and sophistication in analyzing. Today I will be showing how ...

How to Combine Date and Time in One Cell in Excel (4 Methods)

While making a time log of activities in Excel, you may want to enter both the date and time in a single cell. In most cases, you may have dates in ...

How to Combine Rows into One Cell in Excel

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)

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)

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)

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

ExcelDemy
Logo