How to Copy Multiple Sheets to a New Workbook in Excel (4 Methods)

  Method 1 - Applying Move or Copy Command Steps: Select the worksheets of your source workbook. Our dataset has two sheets, "Data 1" ...

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

The sample dataset contains 5 Product Names and Product Codes,where the product codes contain extra spaces before the numbers. Method 1 - ...

How to Use SUM Formula Shortcut in Excel (2 Simple Ways)

Method 1 - Use Keyboard Shortcut Steps: Select a cell in the Expenditure Click on CTRL + =. Press the ENTER button to have the ...

How to Create a Custom Formula in Excel (2 Practical Examples)

Despite all the built-in functions provided by Excel, we may need to create a different function to get our job done. Excel lets us create our own ...

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

Download the Practice Book Multiplying Column by Number.xlsm 3 Easy Methods to Multiply a Column by a Number in Excel In the ...

How to Use the Sheet Name in a Dynamic Formula in Excel – 3 Methods

There are 4 datasets containing information about sales representatives and their sales: Quarter 1, Quarter 2, Quarter 3, and Quarter 4. ...

How to Use Format Painter for Multiple Cells in Excel (7 Methods)

We have a dataset of a List of Fruits and Their Colors. We will use Format Painter to copy the cell format. Method 1 - One-Click Process ...

How to Copy Excel Sheet to Another Sheet with Same Format

In the picture below, we have three columns of salespersons, their salaries, and states. We'll copy the dataset to another sheet and keep the ...

Transpose Data in Excel (Applying Functions, Commands, and VBA)

Download Practice Workbook Transpose Data.xlsm Method 1 - Using Excel Paste Special Tool to Transpose Data Press Ctrl + C to ...

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

In this article, we will demonstrate the methods available in Excel to merge two consecutive rows into one single row. We'll use the dataset below, ...

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

How to Copy Rows in Excel (7 Easy Ways)

Let's use an Employee List. This dataset includes the ID, Name, and Department in columns B, C, and D, respectively. Method 1 - Using the ...

How to Merge Cells Vertically Without Losing Data in Excel

To demonstrate our methods of merging cells vertically without losing data, we'll use the following dataset of some Book Records, and merge the books ...

Absolute Reference in Excel – 4 Examples

  The Absolute reference locks the referred cell. If you use an absolute reference, the cell won’t change after dragging the Fill Handle. ...

Difference Between Absolute and Relative Reference in Excel

In Excel, there are two main types of references: Relative and Absolute (although there is another reference type called a mixed reference). In this ...

How to Repeat Formula Pattern in Excel (8 Easy ways)

  In the following dataset, we have 8 columns and 9 rows. We have some empty cells where we will repeat formula patterns in various ways to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo