I opened a spreadsheet this week that weighed 10.2 megabytes. It had about 80 rows of data in it.
For scale, 80 rows of names and dates should come in somewhere around the size of a long email. This one was big enough to bounce off some inboxes, took its time opening, and made my laptop fan think about its choices. The Museum of Regrettable Spreadsheets has since accessioned it as 2026.046, under the title Formatted to the Horizon. It’s the heaviest work in the collection, and it’s carrying almost nothing.
Here’s what was going on, how to tell if one of yours has the same problem, and how to fix it in about five minutes.
Where the weight comes from
A spreadsheet file doesn’t only store what you typed. It stores everything Excel thinks you care about, and Excel is generous about what that includes.
Formatting nobody can see. Somebody wanted the sheet to look nice, so they selected everything and set a font, a fill and some borders. Sometimes Excel stores that once for a whole column and moves on. Sometimes, depending on how the formatting got there (pasted in, applied to a big block, dragged down past the data), it writes it down cell by cell. A sheet has 1,048,576 rows and 16,384 columns. You don’t need to format all of them to get into trouble; a few hundred thousand empty, carefully bordered cells will do it.
A “used range” that never shrank. Excel keeps track of the last cell it thinks you used. If someone once typed in row 50,000, or pasted a column that ran long, Excel remembers, even after the cell was cleared. Everything between your real data and that ghost is part of the file now.
Pasted-in styles. Every time you copy cells from someone else’s workbook, their cell styles come along for the ride. Do that for a few years and a file can carry hundreds of styles with names like “Normal 2 3 4,” most of them unused. Some old files hit Excel’s ceiling and start refusing new formatting.
Conditional formatting that multiplied. Copying and pasting rows can quietly split one rule into dozens of near-duplicates. Each one gets checked every time the sheet recalculates.
Pictures at full size. A logo pasted straight from a phone photo can be several megabytes on its own, even when it’s displayed the size of a postage stamp.
Why it matters
A heavy file is slow to open, slow to save and slow to share. Shared drives sync it more slowly. Email servers start bouncing it. It’s more likely to corrupt, and when it does, it takes your 80 rows with it.
It’s also a symptom. A file that’s grown this much invisible weight has usually been passed through a lot of hands, and each of them added something without being able to see what anyone before them had done.
How to check yours
Press Ctrl+End. That jumps to the last cell Excel thinks you’ve used. If your data ends in row 80 and Ctrl+End takes you to row 1,048,576, you’ve found it.
Look at the file size next to the data. A rough rule: a few thousand rows of plain text and numbers should usually come in under a megabyte. If yours is ten times that and you don’t have photos in it, something’s hiding.
Open Cell Styles (Home tab). If the list scrolls for a long time, you’ve inherited somebody’s styles.
Open Conditional Formatting, then Manage Rules, and set it to show “This Worksheet.” If you see the same rule repeated with slightly different ranges, that’s the multiplication.
How to fix it
Save a copy first. Then:
- Delete the empty rows below your data. Click the row number just below your last real row, press Ctrl+Shift+Down Arrow to select everything to the bottom, then right-click and choose Delete. Delete, not Clear: clearing removes the contents, deleting removes the rows.
- Do the same for the columns to the right of your data, with Ctrl+Shift+Right Arrow.
- Save, close and reopen. Excel only resets the used range when the file is saved. Press Ctrl+End again; it should land at the end of your real data now.
- If you have a newer version of Microsoft 365, look for Check Performance on the Review tab. It finds formatting sitting in empty cells and offers to clean it up for you.
- Merge the duplicate conditional formatting rules into one rule per job, and delete the unused cell styles (right-click a style, Delete). There are free add-ins that remove unused styles in bulk if there are hundreds.
- Compress pictures: select one, then Picture Format, Compress Pictures, and apply it to all pictures in the file.
What it’s really telling you
None of this is anybody’s fault. Making a sheet look tidy is a kind instinct, and copying from last year’s file is how most work gets done. But a file that’s ten megabytes heavier than its data is a file nobody has been able to see all of, and that’s worth knowing about before it’s the only copy of your attendee list.
If you’ve got one that’s this heavy, the Museum would like a screenshot. If you’d rather have it fixed, that’s the other half of the job.