Latest Blog Posts

Excel VBA: Create New Line in MsgBox (6 Examples)

Example 1 - Use vbNewLine to Add New Line in MsgBox Using Excel VBA We will show “Hello!” in the first line and “Welcome to ExcelDemy” in the second ...

How to Separate Numbers from Text in Excel VBA – 3 Methods

Quick View Public Function SeparateText(Rng As Range, Number As Boolean) As String Dim a As Long Dim b As String a = VBA.Len(Rng.Value) For i = ...

How to Extract Multiple Numbers from a String in Excel – 6 Methods

The dataset showcases  ID (7 digits), Name, and ZIP Code (5 digits) in a single cell. To extract ID and ZIP Code:   Method 1 - ...

Move and Size with Cells in Excel (3 Examples)

In this article, we will describe how to move and size objects with cells in Excel using the Move and size with cells property. Checking this option ...

How to Move Highlighted Cells in Excel (5 Ways)

We'll use the data of 10 employees of a company. Their names and salaries are in columns B and C. We will highlight the entities that are in the ...

Move One Cell to Right Using VBA in Excel: 3 Methods

Method 1 - Move One Cell to Right Using Range Property Steps: Open the Developer tab. You can open it by pressing Alt+F11, or you can customize ...

How to Extract Specific Numbers from a Cell in Excel (11 Ways)

Consider the following dataset containing the product codes and sales records of some items. The product codes are created with a combination of the ...

[Fixed!] Rows and Columns Are Both Numbers in Excel

Usually, the rows are labeled in numbers and the columns in letters in our Excel worksheets. But, there are some instances where this setting can get ...

How to Calculate Profit Percentage in Excel (3 Methods)

For each of the three methods in this tutorial, we'll assume that you're working from the following dataset of a clothing store with their selling ...

How to Separate Numbers in One Cell in Excel (5 Methods)

We will use a dataset that contains the Department and the ID Number of some employees, with the Name and ID Numbers together in one cell. ...

Excel VBA: Set a Range by Row and Column Number – 3 Examples

This is a quick overview. Method 1 - Set a Range by Row and Column Number Using the Cell Address in VBA To set B4:D13, use ...

How to Rearrange Rows in Excel (4 Ways)

Sometimes, while working in Microsoft Excel we may feel the need to rearrange rows according to our convenience. Suppose, we have a dataset like the ...

How to Make a Bulleted List in Excel (9 Methods)

In Microsoft Word, it is easy to make a bulleted list with just a single click. But in Excel is it possible? Yes, it is. Today in this article, I am ...

How to Create Collapsible Rows in Excel (4 Methods)

The following Item Price List table shows the Month, Item, and Price columns. We will collapse the rows of this table. Method 1 - Creating ...

Auto Generate Invoice Number in Excel Template (4 Quick Steps)

Suppose we invoice a certain company repeatedly using an Excel Invoice Template. We want an auto generated invoice number every time we open the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo