Latest Blog Posts

How to Print Labels in Excel (With Easy Steps)

In this article, we will learn about how to print labels in Excel. Labeling is essential in terms of marketing a product, the address of a person to ...

How to Center the Print Area in Excel – 4 Methods

The dataset contains the salary statements of the sales representatives. Method 1 - Using Keyboard Shortcuts to Center the Print Area in ...

How to Turn Off AutoFill in Excel (3 Quick Ways)

We may use Excel's AutoFill tool to fill a list of similar values or a sequence of consecutive entries. It's generally shown at the bottom-right ...

How to Use VBA Space Function in Excel (3 Examples)

In this tutorial, I will explain the details of the excel VBA Space function along with some examples. This function can only be used in VBA code. ...

How to Generate Random Number with Excel VBA (4 Examples)

By using the built-in Rnd function in VBA Excel, we can generate a random number easily. These generated random numbers are usually in the range of 0 ...

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo