Using Excel VBA to Save a Workbook as a New File in the Same Folder – 3 Examples

The sample Excel workbook contains 3 worksheets: ‘VBA-1’, ‘VBA-2’ and ‘VBA-3’. Each worksheet contains the same dataset (B4:D8). To save a new ...

How to Clear Contents Without Deleting Formulas Using VBA in Excel: 4 Methods

Method 1 - Clear Contents from Range Without Deleting Formulas Using VBA in Excel STEPS: Go to the Developer tab and select Visual Basic. It ...

How to Remove Grand Total from Pivot Table (4 Quick Ways)

We’ll consider the following dataset in B4:D14 cells which shows the Item names, their Category, and the Sales in USD. Method 1 - Using ...

How to Collapse the Table to Show the Grand Totals Only – 5 Methods

To collapse the table and display the Totals only:   Insert an Excel Pivot Table (Insert > Pivot Tables) to customize data ...

Excel VBA to Add Sheet to Another Workbook (3 Handy Examples)

Do you want to add a sheet to another workbook in Excel? Yes, then you are in the right place! You can add a sheet in Excel in different ways. ...

How to Create Scenarios in Excel (With Easy Steps)

In this tutorial, I am going to show you the step-by-step procedures to create scenarios in Excel. The Scenario Manager can create simple summaries ...

How to Show Grand Total in Pivot Table (3 Easy Methods)

The following dataset has the Product, Sales, and Profit columns. Using this sample dataset, we will insert a Pivot Table. Method 1 - ...

How to Select and Skip Columns in Excel – 4 Methods

The sample dataset showcases Name in column B, ID in column C, EEE, ME, and CE in columns D, E, and F. Method 1 - Selecting a ...

How to Create Hierarchy in Excel (3 Easy Ways)

In Excel, the term “hierarchy” has two distinct meanings. The first definition refers to a chart that aids in visualizing a hierarchical structure, ...

How to Calculate Auto Loan Payment in Excel (with Easy Steps)

If you're looking to calculate your auto loan payment in Excel, there are a few things you'll need to know. First, you'll need to know the loan ...

How to Make Trial Balance in Excel (with Easy Steps)

In this article, we discuss how to make a Trial Balance in Excel using a dataset as a Ledger, and provide a free downloadable Trial Balance template. ...

How to Clear Contents in Excel Without Deleting Formatting

  Method 1 - Using an Excel Keyboard Shortcut to Clear Content Without Deleting Formatting We have a dataset containing 5 employees' names, ...

Excel VBA to Clear Contents of Range (3 Suitable Cases)

Consider a dataset where you may want to reuse existing cells. You can use VBA code to clear the contents of an Excel file. Here's an overview of our ...

How to Add the Grand Total to a Bar Chart in Excel – Easy Steps

The sample dataset showcases 4 different products and their sales in 3 quarters. STEP 1 - Insert a Spacing and a Grand Total Column ...

How To Open Folder and Select File Using Excel VBA: 4 Examples

Example 1 - Using GetOpenFilename to Open Folder and Select File Option 1 - Setting Variable as Variant Steps: Go to the Developer tab. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo