WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Formatting Text in Excel

Formatting Text in Excel

How to Format Text in Excel?

Formatting of text in excel includes, color, font name, font size, alignment, font appearance in terms of bold, underline, italic, background color of the font cell, etc.

You can download this Formatting Text Excel Template here – Formatting Text Excel Template

#1 Text Name

You can format the text font from default to any of the other available fonts in excel. Enter any text value in any of the cells.

Excel Formatting Text Example 1

Under the HOME tab, you can see so many formatting options available.

Example 1.1

Formatting has been categorized into 6 groups, i.e., Clipboard, Font, Alignment, Number, and Style.

In this, we are formatting the font of cell value A1, i.e., “Hello Excel.”For this under the “Font” category, click on the drop-down list of “Font Name” and select the font name as you wish.

Excel Formatting Text Example 1.2.0

In the above, I just hover on one of the font names, and we can see the immediate preview in cell A1. If you are satisfied with the font style, then click on the name to fix the font name for the selected cell value.

#2 Font Size

Similarly, we can format the font size of the text in a cell as well. For this, just type the font size in numbers next to the font name option.

Example 1.3.0

Enter the font size in numbers to see the impact.

Excel Formatting Text Example 1.4.0

#3 Text Appearance

We can modify the default view of the text value as well. We can make the text value look bold, italic, and underlined as well. For this, just look at font size and name options; you can see all these three options.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 1.5.0

As per the format, you can apply formatting on text value.

  • We have applied Bold formatting using Ctrl + B shortcut excel key.

Example 1.7

Excel Formatting Text Example 1.6

  • To apply Italic formatting, use Ctrl + I shortcut key.

Excel Formatting Text Example 1.8

Example 1.10

  • And to apply to Underline formatting, use Ctrl + U shortcut key.

Excel Formatting a Text Example 1.11

Example 1.12

  • The below image shows a combination of all the above three options.

Excel Formatting Text Example 1.13

  • Just in case if you want to apply double underline, then click on the drop-down list of underline options and choose “Double Underline.”

Example 1.14

#4 Text Color

You can format the default font color (black) of text to any of the colors available.

Excel Formatting Text Example 1.15

  • Click on the drop-down list of the “Font Color” option and change as per your wish.

Example 1.16

#5 Text Alignment

We can format the alignment of the excel text under the “Alignment” group.

  • We can do a left alignment, right alignment, middle alignment, top alignment, and bottom alignment.

Example 1.17

#6 Text Orientation

One more important thing under Alignment we can do is “Orientation” of the text value.

Under orientation, we can rotate text values diagonally or vertically.

Excel Formatting Text Example 1.18

  • Align Counterclockwise

 Example 1.19

  • Align Clockwise

Excel Formatting Text Example 1.20

  • Vertical Text

Example 1.20

  • Rotate Text Up

Excel Formatting Text Example 1.22

  • Rotate Text Down

 Example 1.23

  • And under format cell alignment, we can have many other kinds of stuff as well. Click on this option and experiment with some of the techniques to see the impact.

Excel Formatting Text Example 1.24

#7 Conditional Text Formatting

Let’s see how to apply conditional formatting to Text in Excel.

We have learned some of the basic text formatting techniques. How about the idea of formatting only a specific set of values from the group or if you want to find only duplicate values or find unique values.

These are possible through the conditional formatting technique.

For example, look at the below list of cities.

Excel Formatting Text Example 2

From this list, let’s learn some formatting techniques.

#1 – Highlight Specific Value

If you want to highlight only the specific city name, then we can highlight specific city names only. Assume you want to highlight the city “Bangalore,” then select the data and go to conditional formatting.

 Example 2.1

Click on the drop-down list in excel of Conditional Formatting >>> Highlight cells Rules >>> Text that Contains.

Excel Formatting Text Example 2.2

Now we will see the below window.

 Example 2.3

Now enter the text value that we need to highlight.

Excel Formatting Text Example 2.4

Now from the dropdown list, choose the formatting style.

Example 2.5

Click on Ok; it will highlight only the supplied text value.

Excel Formatting Text Example 2.6

#2 – Highlight Duplicate Value

In order to highlight duplicate values in excel, follow the below path.

Conditional Formatting >>> Highlight cells Rules >>> Duplicate Values.

Excel Formatting Text Example 2.7

Again from the below window, select the formatting style.

 Example 2.8

This will highlight only the text values that appear more than once.

Excel Formatting Text Example 2.9

#3 – Highlight Unique Value

Like how we have highlighted duplicate values similarly, we can highlight all the unique values, i.e., “text value that appears only once.”From the duplicate values, the formatting window chooses the “Unique” value option.

Example 2.10.0

This will highlight only the unique values.

Excel Formatting Text Example 2.11

Things to Remember

  • Learn shortcut keys to quickly formatting text values in excel.
  • Based on certain conditions, if you want to format some text values, then use conditional formatting.

Recommended Articles

This has been a guide to formatting text in excel. Here we discuss how to format text using text name, font size, text appearance, text color, etc., along with practical examples and downloadable excel templates. You may learn more about excel from the following articles –

  • Conditional Formatting in Dates
  • Conditional Formatting along with Formulas
  • Combine Text From Two Or More Cells
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Formatting Text Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More