Excel Basics

Excel Current Date Formula (with 11 Easy Examples)

To get the current date in Excel, you generally have to utilize the TODAY() formula. This article will show you the various ways of how to apply the ...

Remove First Character from String in Excel (4 Ways)

Many times, you need to remove the first character from a string of your database in Excel. The article will help to know 4 different ways to remove ...

How to Copy Multiple Sheets in Excel to New Workbook

Excel plays a great role for professionals. We get stuck in Excel sometimes. Lots of functions and formulas for different problems. But some problems ...

How to Remove Space in Excel before Numbers (3 Ways)

Space between numbers is a common situation while working on Excel. Sometimes, they are intentional. Sometimes, it is a mistake. We give input ...

Sum Formula Shortcuts in Excel (3 Quick Ways)

The SUM function is one of the basic and most frequent functions available in Excel. We use this function to add up values within a row or a column ...

How to Create a Formula in Excel (5 Ways)

Excel can be used to perform any type of calculation and creating a formula is the basis of the calculation. In this article, you will learn how to ...

How to Multiply a Column by a Number in Excel (4 Easy Methods)

We often use multiplication in Excel. For that, there are a lot of methods. In this article, I’ll show 4 easy methods to multiply a column by a ...

Excel Sheet Name in Formula Dynamic (3 Approaches)

Sometimes depending on the scenario, you may need to use worksheet names in the formula, providing the sheet name manually is a tedious task. To ...

Paste Options in Excel: A Complete Guideline

When we copy (Ctrl+C) or cut (Ctrl+X) and paste (Ctrl+V) cells, everything in the source cell-data, formulas, formatting, transpose, etc.- are pasted ...

How to Use Format Painter in Excel for Multiple Cells (6 Quick Ways)

To copy formatting from one cell to another we can use Format Painter in Microsoft Excel. It's an amazingly efficient and simple process to format ...

How to Copy Excel Sheet to Another Sheet with Same Format

In Microsoft Excel, there are several methods to copy a sheet to another sheet with the same format. In this article, I’ll show 4 quick simple ...

How to Merge Text from Two or More Cells into One Cell (Easiest 6 ways)

If you are looking for some simple and easiest ways to merge text from two or more cells into one cell, then you are in the right place. Merging ...

Copy Conditional Formatting in Excel

Conditional Formatting in Excel enables you to quickly format a cell (or range of cells) based on the value or the text in it. It can help you to ...

How to Transpose in Excel (5 Easy Ways)

Transpose of Excel is very useful to us. Most of the time we do this manually. But here we are going to describe some easy methods to transpose. ...

How to Merge Two Rows in Excel (4 Easy Ways)

In this article, I am going to discuss the available methods offered by Excel to merge two consecutive rows into one single row. I use Merge & ...

Editor choice How to Merge Two Rows in Excel (4 Easy Ways)
ExcelDemy
Logo