Excel Performance Problems

How to Fix Excel Responding Slowly When Formatting Text in Cells

Tauseeq Magsi Oct 22, 2026 868 views

Question details

Excel responds slowly or freezes when formatting specific parts of text, such as applying bold or color formatting.

How to Improve Excel Performance When Formatting Text in Cells

Product: Microsoft Excel
Device & OS: not provided
Scenario: Applying bold, color, or other font formatting to partial text strings within cells across a workbook, either manually or via VBA.
Observed behavior: Excel suffers a severe performance drop, becoming sluggish and unresponsive across multiple computers and software versions.

Before you start

Create a backup copy of your workbook before making bulk changes to formatting, as clearing formats across large ranges cannot always be easily undone.

Solution 1Recommended

Clean Excess Cell Formatting from the Worksheet

Removing unused formatting applied to entire blank columns or rows can significantly reduce workbook memory usage and restore performance.

A common cause of poor performance in Excel is excessive formatting applied to empty cells. When you format entire columns or rows, Excel allocates memory for all 1+ million rows, which drags down performance during simple text formatting operations.

Select empty columns

Click the first empty column header to the right of your actual data. Press 'Ctrl + Shift + Right Arrow' on your keyboard to highlight all remaining empty columns.

Clear formats

Navigate to the 'Home' tab on the Excel ribbon. In the 'Editing' group, click on 'Clear' (the eraser icon) and select 'Clear Formats' from the drop-down menu.

Select empty rows

Click the first empty row number below your actual data. Press 'Ctrl + Shift + Down Arrow' to highlight all remaining empty rows to the bottom of the sheet.

Clear row formats and save

Go to the 'Home' tab, click 'Clear', and choose 'Clear Formats' again. Once finished, save the workbook to apply the memory reduction.

Clean Excess Cell Formatting from the Worksheet

Using the Inquire Add-in: If you have the Microsoft Office Professional Plus edition, you can enable the 'Inquire' add-in from the COM Add-ins menu and click 'Clean Excess Cell Formatting' to automate this process.

Solution 2

Optimize VBA Scripts for Text Formatting

If you are using VBA to apply bold or color formatting to partial text strings, disabling screen updates during macro execution will prevent the interface from lagging.

Free Microsoft Office alternative

Experience Faster Spreadsheet Performance with WPS Office

If Microsoft Excel continues to struggle with lag when handling complex datasets or formatting, consider switching to WPS Office. It is a highly optimized, lightweight, and completely free alternative that handles heavy spreadsheets effortlessly.

Seamless compatibility with Microsoft Excel formats (.xlsx, .xls, .csv) without data lossLightweight architecture that consumes significantly less RAM and system resourcesSmooth performance even when applying extensive manual or conditional formattingFamiliar user interface requiring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel freeze when I format parts of text within a single cell?

When you apply formatting to specific words or characters inside a cell (rather than the whole cell), Excel's rendering engine must calculate the style tags for each character individually. In large files or files with existing excessive formats, this heavily taxes system memory and causes lag.

Does conditional formatting slow down Excel?

Yes. Conditional formatting rules are 'volatile', meaning Excel recalculates them every time any change is made to the worksheet. If applied to entire columns rather than just the active data range, this can severely impact software performance.

How can I reduce my Excel workbook's memory usage?

You can reduce a workbook's memory footprint by deleting completely blank rows and columns, removing unnecessary background colors or borders, deleting unused hidden sheets, and saving the file in the Excel Binary Workbook format (.xlsb).

Excel & Data Problems