Excel Basics

Multiplication Formula in Excel (6 Quick Approaches)

Excel formulas are made for us to calculate problems easily. But there is no fixed multiplication formula in Excel. Today we are going to see some ...

How to Merge and Center Cells in Excel (3 Easy Methods)

When an entry occupies more than one cell and needs to be positioned in the center, Excel offers a couple of methods to go with. In this article, ...

How to Show and Hide Formula Bar in Excel (3 Methods)

Excel formula bar is a tool that can be used to edit any cell values applying a formula. By default, the formula bar is visible in Excel directly ...

How to Copy Formatting in Excel to Another Sheet (4 Ways)

Font, Number, Date types;  Alignment; Bold, Italic Headings; Coloring; Designing; Size of cells; etc. are different kinds of formats available in ...

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 (3 Methods)

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

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

All Paste Options in Excel with Time Saving Shortcuts

Paste options in MS Excel give us the opportunity to choose certain elements and keep them in the destination cells. In this article, we will show ...

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 for multiple cells. It's an amazingly efficient and simple ...

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

ExcelDemy
Logo