Excel Not Keeping Formatting After Saving? Fixes That Work

Excel usually stops keeping formatting because the workbook was saved in a format that cannot store it, the formatting was applied to the wrong cells, or a rule or theme is changing what you see. Save the file as an Excel workbook (.xlsx), format the intended range, then close and reopen that same file to check the result.

Start by checking the file type

The most important first check is the file extension. An .xlsx workbook can store cell formatting, formulas, worksheets, and other standard Excel features. A CSV file, by contrast, stores tabular data as plain text with separators; it does not preserve cell colors, borders, fonts, column widths, or number formats. If a workbook is saved as CSV, Excel may display a warning that some features will be lost.

To keep formatting, use File > Save As, choose a folder, and select Excel Workbook (*.xlsx) in the Save as type list. On Mac, use File > Save As and choose an Excel workbook format in the file-format options. If you need a CSV for another application, keep a separate .xlsx copy as your formatted source, then export a copy to CSV. CSV normally contains only the active worksheet, so it is not a substitute for a complete workbook.

.xlsx: The standard choice for a workbook without VBA macros.
.xlsm: Use this when the workbook contains VBA macros that must be retained.
.xls: The older Excel 97–2003 format. It has legacy limits and may not retain newer workbook features exactly.
.ods: OpenDocument format used by some spreadsheet applications. Moving between formats can change how some features appear.

Saving a macro-enabled workbook as .xlsx removes its VBA macros. If macros matter, choose .xlsm rather than .xlsx. Excel may warn about features that the selected format cannot preserve; read that warning before confirming the save.

Make sure you are reopening the same workbook

A surprisingly common cause is editing one copy and reopening another. This can happen when a file exists in Downloads, on a network drive, in OneDrive, or as an email attachment and several copies have similar names. After saving, use File > Info or the title bar to confirm the workbook name and location, then reopen that exact file. You can also use File > Open > Recent and check the location shown for the workbook.

Use Ctrl+S on Windows to save; on Mac, use Command+S. Saving is not the same as saving a copy to a new location. If you use Save As, note the new folder and filename, since your original may remain unchanged. If the workbook is stored in OneDrive or SharePoint and version history is available, File > Info > Version History may let you review or restore an earlier version. Restoring a version can replace later edits, so check its contents first.

For a useful test, make a small visible change, save, close the workbook, and reopen it from the confirmed location. If the change remains, the original issue may have been a different copy or an unsaved edit. If it disappears, investigate the file format, permissions, or the formatting rules described below.

Check whether formatting is actually missing

What looks like lost formatting may be a display change rather than a failed save. Conditional formatting can override ordinary cell formatting for properties covered by its rules. For example, a cell may have a manually applied green fill, while a conditional-formatting rule turns it red when its value is below a threshold. The underlying manual fill can still be present even though the rule controls the visible color.

To inspect rules, select an affected cell and choose Home > Conditional Formatting > Manage Rules. Check which cells the rule applies to, whether the rule condition is still true, and its priority. If appropriate, edit or remove the rule; avoid deleting it until you know what it is meant to indicate. You can also compare the cell with a nearby cell that has no rule.

Theme colors can also look different if a workbook’s theme changes or the file is opened in another program. A theme color is linked to the workbook theme, whereas a standard color is a fixed selection. Number formats can cause another kind of confusion: a cell containing the value 0.25 might display as 25%, but changing its number format does not change the stored value. If you expected a different display, select the cells and open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then review the Number, Font, Border, and Fill tabs.

Apply formatting to the intended cells

Formatting may appear to vanish when it was applied to only part of the data or to a range that later changed. Before applying a style, select the full intended range, including any new rows that need the same appearance. You can select a range by dragging, or click the first cell and Shift-click the last. Check the Name Box to the left of the formula bar if you want to confirm the selected address.

If data is an Excel table, new rows often inherit the table’s style, but direct formatting and table formatting can interact. Click inside the table and use Table Design to review its style and options. A table style may control banded rows or header appearance, so changing a cell’s fill directly may not produce the result you expect. If you want to format a range as a table, use Home > Format as Table and confirm the selected range and header setting.

Other practical checks include:

Confirm that the cells are not merged in a way that makes the selection or border appear unexpected.
Check whether a row or column is hidden, or whether its height or width is too small to show the result clearly.
Verify that you are formatting the worksheet you intend; a workbook can contain many sheets with similar names or layouts.
If formatting is being copied, use the intended source range and check whether Paste Special pasted values only. A values-only paste does not copy the source formatting.

Sheet protection can prevent some formatting changes. On Windows, check Review > Protect Sheet; if the sheet is protected, Excel may disallow formatting cells, rows, or columns. On Mac, look for the sheet-protection controls on the Review tab. You need permission and, where applicable, the password to change protected settings. Protection is different from a save problem: Excel may simply be preventing the formatting change from being made in the first place.

Look for compatibility and conversion problems

Older .xls files and non-Excel formats can behave differently from .xlsx. Excel may display a Compatibility Mode label for a workbook saved in the older format. Some newer features are not supported there, and converting back and forth between spreadsheet programs can change features or presentation. This does not mean every .xls save removes formatting; it means the format’s age and feature limits make it worth checking when a workbook changes after conversion.

If the file came from another spreadsheet application, save a working copy as .xlsx and compare the important sheets and print layout. Pay particular attention to conditional formatting, fonts, theme colors, borders, and custom number formats. Also check page orientation, scaling, margins, and print areas: these affect printed output, not necessarily the way cells look on screen. A printout that differs from the worksheet is not proof that cell formatting failed to save.

When Excel presents a compatibility warning, treat it as a specific clue. The message identifies features that may be reduced or unsupported in the chosen format. If preserving the original appearance matters, keep an unchanged copy in its original format as well as a working .xlsx version. Do not repeatedly convert the only copy of an important workbook.

Troubleshoot saving, permissions, and sync

If the correct .xlsx file still reopens with changes missing, check whether Excel can save to its location. A read-only file, restricted folder, network interruption, or cloud-sync problem can leave you looking at changes that were not written to the file you later opened. Look for a read-only notice, a save error, or a sync status warning. If necessary, use Save As to save a new copy in a folder where you have permission, then reopen that copy and verify it.

For a workbook shared with other people, consider whether a second person or another open copy could be making edits. Cloud coauthoring can show updates from collaborators, and conflicting copies can make it difficult to tell which version contains the formatting. Agree on one working file, allow sync to finish, and check the saved file after closing it. If the workbook is important, make a separate backup before experimenting.

Excel’s AutoSave can help save changes to supported cloud files, but it does not make CSV retain formatting or guarantee that a different copy is being edited. AutoRecover is intended to help recover unsaved work after certain interruptions; it is not a replacement for saving the correct workbook format and location. If Excel displays a save error, resolve that error rather than assuming the formatting has been stored.

A reliable way to prevent formatting loss

Use a short repeatable process whenever formatting matters, especially before sending a workbook to someone else:

Keep an untouched backup of the original file.
Save the working workbook as .xlsx, or .xlsm if it contains macros that must remain.
Apply formatting to the complete intended range and inspect conditional-formatting rules or table styles that may affect the display.
Save with Ctrl+S on Windows or Command+S on Mac, and confirm that Excel reports no save error.
Close and reopen the same file from its saved location. Check both the worksheet display and, if relevant, Print Preview.
If you need a CSV or another export, create it separately and retain the formatted Excel workbook.

This verification matters because a workbook can look correct before saving even when the chosen output format cannot store all of its features. Reopening tests the actual saved file, not just the version still visible in Excel’s memory.

Frequently Asked Questions

Why does Excel remove formatting when I save as CSV?
CSV stores plain text values separated by delimiters, not Excel cell styling. Save a separate .xlsx workbook to preserve formatting, and use CSV only for the data export.

Does saving as .xlsx keep all my formatting?
.xlsx preserves standard Excel cell formatting and many workbook features. However, it cannot retain VBA macros; use .xlsm for a macro-enabled workbook. Features from other formats may also change during conversion.

Why does my cell color change after I reopen the workbook?
Check Home > Conditional Formatting > Manage Rules. A rule may be setting the visible fill, or a workbook theme may affect theme-linked colors. The color may be overridden rather than erased.

Why does my formatting disappear when I paste data?
The paste option may have inserted values without formatting, or the target range may be controlled by a table style or conditional-formatting rule. Review the paste options and inspect the formatting on the target cells.

Can a protected worksheet stop formatting changes?
Yes. Sheet protection can restrict formatting cells, rows, or columns. Check Review > Protect Sheet and ask the workbook owner for access if you do not have permission to change the protection.

How can I tell whether the formatting was saved?
Save the workbook, close it, and reopen the exact same file from its confirmed location. If the formatting remains, the saved copy contains it; if not, check the file type, rules, permissions, and save or sync status.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.