Advanced Excel

Excel Copy Rows from One Sheet to Another Based on Criteria (5 Ways)

In MS-Excel sometimes we need to copy rows from any worksheet to another worksheet based on different criteria. In this article, I will show various ...

How to Remove Commas in Excel (From Text & Numbers)

In this article, I will show you how to remove commas from the names (placed in the middle/in-between/last) and the numbers in Excel. Download Excel ...

Division formula in Excel for multiple cells

Do you want to know how to use the division formula in Excel for multiple cells? You are in the right place. Let’s start… What is the division ...

How to split a single cell in half in Excel (diagonally & horizontally)

Do you want to know how to split a cell in half in Excel (both diagonally and horizontally)? Want to know how to split a single cell diagonally ...

How to divide columns in Excel (Top 8 easy & quick ways)

In this article, I will show how to divide columns in Excel. I will show several ways. Choose one that best suits your job. So, let’s start. ...

How to insert square root symbol in Excel (7 easy ways)

In this article, I will narrate how to insert square root symbol in Excel. The square root is one of the most used symbols in Excel. I will ...

Add The Footer Page 1 To The Current Worksheet

In this article, I will show you how you can add the footer page 1 to the current worksheet you are working on. Excel has many different options for ...

Perform the Commands to Center the Selected Worksheets

In many cases, after working with your Excel worksheets you may want some of the selected worksheets to be aligned in the center position of the ...

Create a report that displays the quarterly sales by territory

In this article, I will create a report that displays the quarterly sales by territory. You can call it also a dynamic and interactive Excel ...

Perform a Spelling Check on the Active Worksheet of Excel

Spell checking is mandatory sometimes while working in an Excel Worksheet. In this article, we will see how to perform a spelling check on the active ...

Excel Custom Number Format Multiple Conditions

In this article, we are going to discuss the Excel custom number format multiple conditions. We will learn about the meaning and uses of different ...

How to Round Numbers in Excel Without Formula (3 smart ways)

In this article, you will see how to round numbers in Excel without formula. You will get to see a number of processes to round up, round down and ...

Excel Data Validation Based on Another Cell Value

Data Validation is an important feature in Excel. In this article, we will see how Excel data validation based on another cell is created. Data ...

How to change the orientation of a worksheet to Landscape

Sometimes it is convenient to use Landscape page orientation rather than the default Portrait orientation, especially when you have data with a lot ...

How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)

In this article, I will show you a good number of techniques on how to remove leading zeros in Excel. We don’t create all our worksheets ourselves. ...

ExcelDemy
Logo