It started with a panicked Slack message at 9:14 AM: "Our board deck has an Excel embed and it looks completely broken. Presentation is at 2 PM. Can you fix it?"
I've been in enough high-stakes situations to know that "broken Excel" can mean a dozen different things. Formulas returning errors. Formatting that looks fine on your screen but explodes on a projector. Columns so narrow the data is just a wall of pound signs. Whatever the cause, the fix always follows the same disciplined process — and that morning I had about four hours to execute it perfectly.
Here's exactly what I did, and what you should do if you're ever staring down a similarly chaotic spreadsheet before a room full of executives.
Step 1: Diagnose Before You Touch Anything
The worst thing you can do is start reformatting immediately. Open the file, take a breath, and audit what you're actually dealing with. I make a quick checklist:
- Are there broken formula references (#REF!, #VALUE!, #N/A)?
- Is the data layout logical — headers on row 1, no merged cells hiding content?
- Are there inconsistent number formats (some cells showing currency, others plain numbers)?
- Does the sheet use manual color-coding with no legend?
- Are there hidden rows or columns that might contain data decision-makers need?
In this case, I found three #REF! errors caused by someone deleting a source tab, inconsistent currency formatting across a revenue summary table, and — my personal nemesis — aggressively merged cells that broke any attempt to sort or filter the data.
Step 2: Fix the Data Integrity Issues First
Presentation formatting means nothing if the numbers are wrong. I always fix structural and formula errors before touching a single color or font.
For the broken references, I traced each #REF! cell using Formulas > Trace Precedents and manually re-entered the correct values from a backup version the client had in their email. When there's no backup, you use the most recent reliable source — even if that means a phone call to whoever owns the numbers.
For the merged cells, I selected the entire data range, went to Home > Merge & Center > Unmerge Cells, then used Go To Special > Blanks and filled down so every row had complete data. This is tedious but non-negotiable. Merged cells are the enemy of clean executive reporting.
Step 3: Standardize the Number Formatting
Executives read fast. Inconsistent formatting forces their brain to slow down and decode rather than absorb. Every number in a financial summary should follow one consistent logic:
- Currency values in the same column use the same format — I default to $#,##0 for whole numbers or $#,##0.00 when cents matter.
- Percentages are formatted as percentages, not decimals. 0.043 should read 4.3%, not 0.04.
- Large numbers use comma separators — always.
- Negative numbers appear in red with parentheses, e.g., (42,500), not a minus sign that's easy to miss.
I also eliminated any cells formatted as "General" in a data table. General formatting is Excel's way of saying "I'll figure it out" — and it never figures it out correctly in a presentation context.
Step 4: Build a Clean Visual Hierarchy
Now we get to the part most people jump to first — and why their spreadsheets still look bad. Visual formatting only works on top of clean data. With the structure solid, here's the formatting system I applied:
Headers and Labels
Top-row headers got a dark background (I used #1F2D3D, a deep navy) with white bold text at 11pt. This immediately signals to the eye where the table begins and what each column means.
Data Rows
Alternating row shading using a very light gray (#F4F6F8) on even rows. Not zebra stripes with bold colors — subtle banding that helps the eye track horizontally without creating visual noise.
Summary and Total Rows
Bold text, slightly darker background (#DDE3EA), and a top border using a medium-weight line. Summary rows need to stand out, but not shout.
Column Widths
I selected all columns and double-clicked the column border to auto-fit, then manually adjusted any column that auto-fitted too wide or too narrow. The rule: no column should require horizontal scrolling when the sheet is viewed at 85% zoom on a standard laptop screen.
Step 5: Prepare It for Presentation Conditions
A spreadsheet that looks great on your desk looks very different on a conference room projector or a shared screen in a Zoom call. Before finalizing, I do three things:
- Set the print area and page breaks so if anyone prints it, it doesn't fragment mid-table.
- Freeze the top row so headers stay visible when scrolling.
- Zoom to 90% and review at the resolution the presenter will likely use. Bump font sizes up if anything feels small — 10pt is the absolute minimum for data cells, 11pt is better.
I also removed all gridlines from the view (View > Show > Gridlines, uncheck) and let the cell borders I'd manually applied do the work. Gridlines in a presentation context feel unfinished.
The Result
By 12:30 PM, the client had a spreadsheet that matched their brand colors, had zero formula errors, and told a clear financial story at a glance. The 2 PM presentation ran without a hitch.
The honest truth is that most "broken" Excel files aren't beyond saving — they just need someone to work through them methodically rather than reactively. Data integrity first, structure second, visual polish third. In that order, every time.
If your team regularly relies on Excel for executive reporting and you're tired of last-minute scrambles, this is exactly the kind of work we help clients systematize at Helion 360. A well-formatted spreadsheet isn't just about aesthetics — it's about communicating clearly under pressure.