Text Formatting in Excel Archives

How to Add New Line in Excel (3 Effective Ways)

Jul 6, 2024

Download Practice Workbook Inserting New Line.xlsx Method 1 - Add New Line with Keyboard Shortcut Place your cursor where you ...

How to Add New Line in Excel (3 Effective Ways)

Suffix and Prefix in Excel: A Complete Guide: 5 Methods

May 28, 2024

Method 1 - Using Ampersand Operator Add prefix, select cell D5 write this formula, and press Enter. =B5&" "&C5 Use Fill ...

Suffix and Prefix in Excel: A Complete Guide: 5 Methods

What Is the Keyboard Shortcut to Manually Add Line Break in Excel?

Jul 6, 2024

Double-click on the cell >> place the cursor in the required position >> press the Alt + Enter keys simultaneously to enter a new ...

What Is the Keyboard Shortcut to Manually Add Line Break in Excel?

Change Case in Excel

Nov 11, 2025

In this article, you will learn how to change case in Excel in detail. You will get to know about formulas based on different functions to change ...

Excel Address Format (All Things You Need to Know)

Nov 11, 2025

In this tutorial, you will learn how to format addresses in Excel. You will find four different techniques by which you will be able to format your ...

Excel Address Format (All Things You Need to Know)

How to Use Subscript and Superscript in Excel: A Complete Guide

Jul 24, 2024

Understanding Subscript and Superscript In mathematics, computing, and typography: Subscript: A character or symbol written in the bottom-right ...

How to Use Subscript and Superscript in Excel: A Complete Guide

How to Rotate Text in Excel

Nov 11, 2025

In this article, we have discussed 5 different ways in Excel to rotate text. We have also shown you how to rotate text at any custom angle. Then, we ...

How to Wrap Text in Excel (Wrap, Unwrap, Fix Issues)

Jul 26, 2024

Method 1 - Using the Wrap Text Option from the Home Tab Select range D6:D13. Go to the Home tab. Click on Wrap Text in the Alignment ...

How to Wrap Text in Excel (Wrap, Unwrap, Fix Issues)

How to Add and Remove Spaces in Excel

Jul 5, 2024

Method 1 - Adding a Space at a Certain Position with the Ampersand, LEFT, and RIGHT Functions Steps: In cell C5, insert the following formula ...

How to Insert and Remove Carriage Return in Excel

Jul 9, 2024

A carriage return is also known as a line break in an Excel cell. While they are technically different, the traditional meaning of carriage return ...

How to Insert and Remove Carriage Return in Excel

How to Overline Text in Excel (4 Method)

Jul 26, 2024

Method 1 - Using the Accent Option Click the Insert tab. Click on Symbols followed by Equation. Choose Accent and select Bar. ...

How to Overline Text in Excel (4 Method)

How to Draw a Line Through Text in Excel (6 Easy Ways)

Nov 11, 2025

Excel is excellent for working with numbers, but formatting text values in the way you want is not always obvious. The example of strikethrough is ...

How to Draw a Line Through Text in Excel (6 Easy Ways)

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Jul 24, 2024

Dataset Overview We'll use a dataset that holds products sold on certain days. The products that have sold a Quantity of more than 50 (>50) are ...

How to Use a Formula to Find Bold Text in Excel (4 Methods)

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

Jun 16, 2024

How to Use Code in the Visual Basic Editor Go to the Developer tab from the Excel ribbon. Click on the Visual Basic option. In the ...

Excel VBA Codes to Format Cell as Text (3 Easy Examples)

Excel VBA Codes to Bold Text in a String (5 Examples)

Jun 18, 2024

In this tutorial, you will learn how to make a text bold in a string using Excel VBA, along with other related tasks. Example 1 - Bold the ...