Excel Basics Archives - Page 89 of 107

Multiplication Formula in Excel (6 Quick Approaches)

May 14, 2022 Excel Basics

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)

Feb 28, 2022 Excel Basics

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)

May 18, 2022 Excel Basics

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)

May 12, 2022 Excel Basics

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)

May 14, 2022 Excel Basics

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)

Feb 9, 2022 Excel Basics

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)

Feb 26, 2022 Excel Basics

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)

May 14, 2022 Excel Basics

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)

Jun 7, 2022 Excel Basics

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)

May 14, 2022 Excel Basics

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)

May 14, 2022 Excel Basics

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)

May 14, 2022 Excel Basics

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

Mar 24, 2022 Excel Basics

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)

Feb 20, 2022 Excel Basics

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

Jun 6, 2022 Excel Basics

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