How to Remove Print Titles in Excel (3 Methods)

We occasionally need to print exported files or files that we have received from others. In that case, we may face difficulties with print titles ...

Excel VBA to Check If AutoFilter is On (4 Easy Ways)

Sometimes due to technical issues AutoFilter gets hidden, or even though there is no filter applied, Excel shows that there is. In both cases, it can ...

How to Put Numbers in Numerical Order in Excel (6 Methods)

To demonstrate putting numbers in order, we’ll use a dataset with three columns: “No.”, “Name”, and “Car”. Method 1 - Using Context Menu to ...

How to Wrap Text in Excel Cell (5 Easy Ways)

In the following sample, we have applied wrap text to the Excel cell. What Is Wrap Text in Excel? Wrapping text means enclosing long text ...

How to Filter by List in Another Sheet in Excel – 2 Methods

This is the sample dataset. and a list for filtering in the List for Filter sheet.   Method 1 - Filter by List in Another Sheet ...

How to Highlight a Cell in Excel (5 Methods)

There are several ways to highlight a cell in Excel, among them we will demonstrate to you 5 easy and effective methods. How to Highlight a ...

8 Ways to Remove Symbols in Excel

Method 1: Using the Find and Replace Symbol Example Model: Note: We will remove the ‘#’ symbol with Find and Replace. Steps: Select ...

How to Print Excel Sheet with Table (4 Methods + Tricks)

Method 1 - Print Only Table from an Excel Sheet Our sample dataset is in the B4:I79 cell range. The worksheet has a chart, the table, and the ...

How to Highlight from Top to Bottom in Excel (5 Methods)

In Microsoft Excel, we can highlight top to bottom values with the help of conditional formatting. Highlighting top and bottom values with different ...

How to Remove Percentage Symbol in Excel (7 Ways)

The dataset below will be used to demonstrate how to remove percentage symbols in Excel. Method 1 - Use Custom Formatting to Remove the ...

Using a VBA Code to Filter Data in Excel – 8 Examples

The following dataset contains students’ Gender, Status, and Age. Example 1 - Using a VBA Code to Filter Data Based on Text Criteria in ...

[Fixed!] Name Manager Delete Option Greyed out in Excel (3 Reasons with Solutions)

We name ranges in Excel to make workbooks simpler to understand, formulae quicker to enter and analyze, and to construct variable-size ranges to keep ...

How to Filter a Dataset Based on a Cell Value from Another Sheet Using VBA (4 Methods)

Dataset Overview Let’s introduce our dataset first. We have a list of sale details for 4 different products from 2 categories. We want to filter ...

Filter Different Columns by Multiple Criteria in Excel VBA – 3 Methods

This is the sample dataset. Method 1 - Filtering Different Columns by Multiple Criteria Using the VBA With Statement To Filter TVs costing ...

How to Format Cell and Center Text with Excel VBA (5 Ways)

Method 1 - Run a VBA Code to Center Text Horizontally and Format Cell with Excel VBA 1.1 Center an Active Cell Horizontally In the image below; ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo