Office Compatibility Issues

Format Part of a Cell When Excel for iPad or the Web Lacks the Feature

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

Apply different font formatting to only part of the text in an Excel cell.

Product
Microsoft Excel for iPad, Excel for the web, and desktop Excel
Device & OS
iPad and web browser; browser operating system not provided
Scenario
The user wants to apply mixed font colors or strikethrough to selected characters within a single cell.
Observed behavior
Partial-cell font formatting may be unavailable in Excel for iPad and Excel for the web, although it is supported in desktop Excel.
Before you start

Check whether you have access to desktop Excel for Windows or Mac and can open the workbook there. Identify the cell and characters you want to format before editing.

Solution 1Recommended

Apply Partial-Cell Formatting in Desktop Excel

Use desktop Excel to format selected characters when the iPad or web version does not offer the required controls.

1
Open the workbook

Open the workbook in Excel for Windows or Mac using File > Open.

2
Select the text

Double-click the cell, then drag across the characters you want to format.

3
Apply font formatting

Use Home > Font Color to change the selected text color. For strikethrough, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then select Strikethrough on the Font tab.

4
Save the workbook

Choose File > Save, then reopen the workbook on your iPad or in a browser as needed.

Apply Partial-Cell Formatting in Desktop Excel
Check formatting after editing: Feature availability can vary by Excel version. Editing a cell in Excel for the web may remove existing partial-cell formatting, so check the result after making changes.
Free Microsoft Office alternative

Edit Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and support for Microsoft Office formats, making it easier to move existing workbooks into a different workflow. It does not change the features available in Microsoft Excel.

Open and edit spreadsheet workbooks in a familiar interfaceCompatible with Microsoft Excel formats, including XLSXFree, lightweight office suite for everyday document workKeep spreadsheets, documents, and presentations in one application
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I format just one word in an Excel cell on my iPad?

Excel for iPad may not offer the same partial-cell font formatting controls as desktop Excel. Open the workbook in Excel for Windows or Mac, select the characters inside the cell, and use the font controls there.

Can I apply strikethrough to part of a cell in desktop Excel?

Yes. Double-click the cell, select the characters, and press Ctrl+1 on Windows or Command+1 on Mac. On the Font tab, select Strikethrough.

Can editing a cell in Excel for the web remove mixed formatting?

It can. After editing a cell in Excel for the web, check whether its partial-cell formatting remains. If necessary, reopen the workbook in desktop Excel and reapply the formatting.

Is this limitation caused by buying Microsoft 365 through Apple?

Not necessarily. The limitation relates to the features available in Excel for iPad or Excel for the web, rather than how the Microsoft 365 subscription was purchased.

How can I request this feature from Microsoft?

Use the Feedback option in Excel, if available in your version, to describe the partial-cell formatting you need and the device or browser you use.