How to Set Print Area in Excel (5 Methods)

In the sample dataset we only want to print a portion of the content.     Method 1 - Set Print Area From Page Layout Tab ...

Hide Rows in Excel Using Shortcuts, Commands and VBA

Method 1 - Use Format Menu to Hide Rows Click on the row number of a row >> Drag down the cursor or hold the SHIFT key to select ...

Remove Duplicate Rows Except for 1st Occurrence in Excel (7 Ways)

Method 1 - Remove Duplicate Rows Except 1st Occurrence Using Remove Duplicates Feature Select the entire datasheet. In the sample dataset, it is ...

Excel VBA Debug Print: How to Do It?

In this article, I’ll show you how you can debug print in VBA in Excel. You’ll learn to open the immediate window and debug print a complete code, a ...

How to Remove Excel Add-In (3 Quick Ways)

Excel add-ins are used to work with additional functionality in Excel. By default, add-ins are not promptly available in Excel. We need to install it ...

How to Apply Custom Freeze Panes in Excel (3 Easy Ways)

In this article, we will demonstrate how to use custom freeze panes in Excel. We can easily lock the first row or column from the ‘Freeze Panes’ ...

How to Increase Row Height in Excel (Top 4 Methods)

A worksheet in Excel has cells that are cleanly arranged into rows and columns, where the default row height is 15 points and the default column ...

How to Sort by Name in Excel (3 Examples)

Example 1 - Use Sort & Filter Group to Sort Columns by Name To sort names alphabetically. 1.1 Sort a Column by Name Step 1: Select the ...

How to Remove Space in Excel after Text (6 Quick ways)

We have a list of names with unwanted spaces after text. We want to remove those spaces to perform further operations. We have included two columns, ...

How to Fix If Flash Fill Not Recognizing a Pattern in Excel

  Excel Flash Fill Excel Flash Fill is a feature or tool that analyzes entries when users enter them and fills the data after recognizing a ...

How to Make a Numbered List in Excel (8 Methods)

  Dataset Overview We have a dataset that contains information about 10 different students. Student names and their identification numbers are ...

How to Color Alternate Rows in Excel (8 Ways)

For decorating a dataset, you can color alternate rows in Excel. In this article, you will get to know several easiest and shortest methods to do ...

How to Move Rows in Excel (4 Simple & Quick Methods)

A lot of times, we have to move the rows in Excel datasheets to meet certain requirements. This article will show you the simple methods to Move Rows ...

How to Use VBA Len Function in Excel (4 Examples)

In this article, I will describe the details of the VBA Len function along with some examples. Likewise, excel LEN function, VBA Len returns the ...

How to Remove Duplicate Names in Excel (6 Simple Methods)

The following dataset contains the names of some salesmen, their state addresses, sales amounts in dollars, and target achievements. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo