Latest Blog Posts - Page 400 of 587

How to Transpose Column to Multiple Rows in Excel: 6 Methods

Jul 7, 2024

Method 1 - Using Excel TRANSPOSE Function to Transpose Column to Multiple Rows Steps: Type the following formula in cell B12. ...

How to Transpose Column to Multiple Rows in Excel: 6 Methods

Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

Jul 9, 2024

How to Write Code in the Visual Basic Editor To get row and column numbers from cell addresses, we need to open and write VBA code in the Visual ...

Excel VBA: Get Row and Column Number from Cell Address (4 Methods)

How to Fix Excel Cells Not Being Able to Move: 5 Solutions

Jun 16, 2024

Solution 1 – Disabling Scroll Lock in Excel Steps: Right-click on the Status bar at the bottom of the worksheet. Select Scroll Lock to turn ...

How to Fix Excel Cells Not Being Able to Move: 5 Solutions

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

Jul 5, 2024

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

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

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

Aug 2, 2024

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 Separate Numbers from Text in Excel VBA – 3 Methods

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

Aug 2, 2024

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

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

Move and Size with Cells in Excel (3 Examples)

Aug 2, 2024

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

Move and Size with Cells in Excel (3 Examples)

How to Move Highlighted Cells in Excel (5 Ways)

Aug 2, 2024

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

How to Move Highlighted Cells in Excel (5 Ways)

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

Jul 3, 2024

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

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

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

Apr 12, 2024

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

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

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

Nov 11, 2025

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

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

How to Calculate Profit Percentage in Excel (3 Methods)

Jun 16, 2024

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 Calculate Profit Percentage in Excel (3 Methods)

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

Apr 12, 2024

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

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

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

Aug 8, 2024

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

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

How to Rearrange Rows in Excel (4 Ways)

Nov 11, 2025

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