Latest Blog Posts - Page 518 of 589

How to Rotate Text in Excel ( 3 Easy Techniques)

Nov 11, 2025

By default, Excel cells store horizontally aligned text. But for our purposes, very often we need to change the orientation of the text in cells from ...

How to Rotate Text in Excel ( 3 Easy Techniques)

How to Convert General Format to Date in Excel (7 Methods)

Jun 27, 2024

Note: General format in Excel means no specified format. Whenever you enter a numeric or alphanumeric value in a cell, Excel counts them in General ...

How to Convert General Format to Date in Excel (7 Methods)

How to Extract Data Based on Criteria from Excel: 6 Ways

Apr 16, 2024

Let's use a List of Students with Their Obtained Marks. This dataset contains the ID, Name, and their corresponding Marks and Departments in columns ...

How to Extract Data Based on Criteria from Excel: 6 Ways

How to Split One Column into Multiple Columns in Excel

Jul 11, 2024

Here's an overview image of splitting a column into multiple ones. Method 1 - Using Text to Columns to Split One Column into Multiple ...

How to Split One Column into Multiple Columns in Excel

How to Remove Blank Lines in Excel (7 Methods)

Jul 24, 2024

Dataset Overview In our dataset we have data of different members of a club. Our dataset contains several blank lines. We will delete these empty ...

How to Remove Blank Lines in Excel (7 Methods)

How to Find Duplicate Rows in Excel (5 Quick Ways)

Jun 14, 2024

Here's an overview of finding duplicated values across rows. How to Find Duplicate Rows in Excel: 5 Quick Ways We will use some ...

How to Separate Two Words in Excel (6 Easy Ways)

Apr 16, 2024

The following image shows one of the ways to separate two words in Excel. Read on to learn more. Let’s say we have a dataset containing a ...

How to Separate Two Words in Excel (6 Easy Ways)

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

May 28, 2024

Cells(2,3).EntireRow.Insert This line inserts a row above cell C2 (Row 2, Column 3). Insert Rows Based on Cell Value with VBA: 2 ...

Insert Rows in Excel Based on Cell Value with VBA (2 Methods)

How to Paste Transpose in Excel Using Shortcut: 4 Methods

Jul 7, 2024

Method 1 - Using Ribbon Paste Shortcut to Transpose in Excel We can transpose by using the Ribbon commands. The process is given below: Steps: ...

How to Paste Transpose in Excel Using Shortcut: 4 Methods

How to Convert Text to Date in Excel (10 Ways)

Jul 29, 2024

Here's an overview of a list of dates in textual values that will be converted to dates. How to Convert Text to Date in Excel: 10 Ways We ...

How to Split a Cell into Two Rows in Excel (3 Easy Ways)

Jun 24, 2024

Here's an overview of splitting a cell into two rows in Excel. We'll use dataset with two columns: Author and Book Name. There are some cells ...

How to Split a Cell into Two Rows in Excel (3 Easy Ways)

How to Create an Invoice using an Excel Formula – 8 Steps

Aug 13, 2024

This is the sample dataset. Download Practice Workbook Download this practice workbook. Invoice Excel Formula.xlsx Include: ...

How to Create an Invoice using an Excel Formula – 8 Steps

How to Convert Date to Text Month in Excel (7 Quick Ways)

Nov 11, 2025

When we enter a date in Excel then it is possible to extract the month name from the date. This article will guide you with 7 quick useful methods to ...

How to Convert Date to Text Month in Excel (7 Quick Ways)

How to Delete Row If Cell Contains Specific Values in Excel?

Jul 29, 2024

We will be using a sample dataset that contains the Name and Age of some people. Method 1 - Using Find and Replace to Delete a Row If a ...

How to Delete Row If Cell Contains Specific Values in Excel?

How to Convert Text to Number in Excel with VBA

Jun 16, 2024

How to Identify Numbers Formatted as Text Take a look at this dataset. We have some numbers in a column. Though we have numbers ...