How to Delete Blank Columns in Excel (4 Quick Ways)

Here we have three blank columns (columns D, E, and G) in our working range that we need to delete. Method 1 - Deleting Blank Columns in ...

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

To demonstrate how to merge and center cells in Excel, we’ll use the following dataset, containing some football players' names and descriptions. ...

How to Show and Hide the Formula Bar in Excel – 3 Methods

This is an overview.   How to Show the Formula Bar in Excel Method 1 - Using the Ribbon Click View tab and check Formula Bar ...

How to Copy Formatting in Excel to Another Sheet (3 Easy Ways)

In this article we will copy the format of a certain dataset and paste it to another sheet like the image below.     Method 1 ...

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 Create a Formula in Excel (5 Easy 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 (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 Transpose in Excel VBA (3 Easy Ways)

One of the most important and widely used activities that we have to accomplish while working in Excel is to transpose a data set. Today I’ll show ...

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 Paste Options in Excel

Paste Options in MS Excel gives 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 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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo