Formatting Issues

How to Change Part of a Cell's Font and Color in Excel for iPad

Maira Mehtab Sep 27, 2026 870 views

Question details

The user wants to apply different fonts or colors to specific letters or numbers within a single spreadsheet cell using an iPad.

Product: Microsoft Excel for iPad
Device & OS: iPadOS
Scenario: Formatting specific parts of the text inside a single cell rather than applying the format to the entire cell.
Observed behavior: Excel for iPad has limited support for partial-cell rich text formatting, often disabling the font and color controls when individual characters are selected.

Before you start

Make sure you are running the latest version of Excel from the App Store, as Microsoft occasionally updates feature availability for mobile platforms.

Solution 1Recommended

Check Partial Formatting Availability on iPad

Verify if your current version of Excel for iPad supports applying formats to specific text within a cell.

Depending on the version of your app and iOS, partial-cell formatting capabilities may vary.

Enter Edit Mode

Double-tap the cell containing the text you want to modify to enter edit mode.

Select Specific Text

Tap and drag the text selection handles to highlight only the specific letters or numbers you wish to format.

Apply Formatting

Check the Home tab on the top ribbon. If the font, color, and size controls are active, select your desired styles. If these options are grayed out, your iPad version does not support partial-cell formatting.

Feature Limitation: If the controls are disabled when text is selected, you must format the entire cell at once or use a desktop computer for partial text formatting.

Solution 2

Use Desktop Excel for Advanced Cell Formatting

Use Excel on a Mac or Windows PC to bypass the iPad's mobile limitations for rich text formatting.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Editing

If you are frustrated by the mobile limitations of Microsoft Office, consider switching to WPS Office. It provides an intuitive, lightweight, and highly compatible workspace for your spreadsheets, documents, and presentations across all platforms.

1. Download the App: Get WPS Office for free from the Apple App Store on your iPad.
2. Open Your Files: Sign in and open your existing Excel spreadsheets directly within WPS Office.
3. Edit Seamlessly: Enjoy a robust set of editing and formatting tools designed for mobile and desktop productivity.

Excellent compatibility with Microsoft Excel formats (.xlsx, .xls, .csv).Free and lightweight alternative to standard Office suites.Familiar, user-friendly interface that requires no learning curve.Seamless cloud sync across iPadOS, iOS, Android, Windows, and macOS.

microsoft office alternative - wps office

Frequently Asked Questions

Why are the font and color options grayed out when I select text in a cell on my iPad?

Excel for iPad has limited support for rich text formatting within a single cell. When you highlight a portion of text inside a cell, the app may disable formatting controls because it currently only supports applying formats to the entire cell at once.

Will partial cell formatting applied on a desktop show up on my iPad?

Yes. If you apply different colors or fonts to specific words within a cell using a Mac or Windows PC, Excel for iPad will display the formatting correctly, even though you cannot edit that specific partial formatting directly on the iPad.

Can I use bold or italics on partial text within an iPad Excel cell?

Similar to font and color changes, partial bold or italic formatting may be restricted on the iPad version of Excel. If the options become disabled upon selecting the text, you will need to perform these specific text edits on a desktop version.

Document & File Issues