Your Excel workbook is showing too much—use the 10% rule to fix it

If your Excel workbook shows everything at once, it's harder to use than it needs to be. The fix is simple: only surface what the user actually needs to see and hide the rest. Let me introduce you to the 10% rule.

The 10% rule: Why less is more in Excel

Avoid overwhelming your audience with the engine room

Most spreadsheets suffer from what I call "The Wall of Data" effect. You open a file, and you're immediately confronted with 40,000 rows of raw exports, 15 columns of intermediate helper math, and a tiny, lonely chart buried somewhere in cell Z100. It's the digital equivalent of handing someone a bag of watch parts instead of just telling them the time.

In reality, only a small portion (roughly 10%) of your workbook should ever be visible to the end user. The other 90%—the messy data imports, lookup tables, and complex formulas—should be tucked away. Showing everything doesn't make a workbook clearer; it just makes it harder to scan. Narrow the field of vision, and you naturally guide the user to the only thing that matters: the insight.

Do this: Set up your workbook for user-friendliness

• Keep only KPIs, summaries, and final outputs on visible sheets.

• Move raw inputs, intermediate calculations, and lookup tables into separate sheets.

• Remove any formulas or working data from user-facing areas.

Once you do this, your workbook stops being a document people explore and, instead, becomes something they use.

Separate your layers to prevent breakage

Create a structural wall between data and design

Messy workbooks tend to fall apart in predictable ways. A small change in one place can ripple across calculations elsewhere, especially when raw data, formulas, and visuals all live side by side. Someone cleaning up a table might delete a row that looks unused but quietly feeds a calculation three sheets away.

Set this up before building anything else.

Do this: Build the separation

To make the 10% rule work in practice, structure your workbook around three dedicated layers : a data layer, a logic layer, and an output layer.

• Create separate worksheets for data, logic, and output.

• Keep all imports and pasted data in the data layer only.

• Build all formulas and calculations exclusively in the logic layer.

• Pull only final results into the output layer.

When those layers are separated, mistakes stay contained.

Build a dedicated dashboard layer

Treat your spreadsheet like a functional app

While your output layer is where your final numbers live, the dashboard is the interface that presents them. Think of the output tab as the stage, and the dashboard as the performance—one is the physical space in your workbook, and the other is the polished, interactive experience your audience actually sees.

Instead of forcing someone to scroll through rows of data, a well-designed dashboard lets them switch views instantly with drop-down menus , slicers, and timeline filters . Then, tools like the Camera feature (which creates live linked snapshots of cells) let you present results cleanly without exposing the formulas underneath.

Good dashboards also rely on restraint: clear headers, intentional spacing, and minimal visual noise. You might also hide the gridlines and headings to give your overview a cleaner, app-like feel.

Do this: Shape the output into a dashboard

• Add drop-down menus, slicers, and timeline filters that control the output layer.

• Replace raw tables with summaries, KPIs, and charts.

• Format the output sheet so that it looks less like a spreadsheet and more like a professional web page or app.

For example, selecting a region from a drop-down menu or slicer can instantly update the dashboard by pulling different results from the output layer—without exposing any underlying data or formulas.

Use intentional hiding for cleaner collaboration

Protect your logic without overwhelming your users

Visibility plays a bigger role in usability than most people realize. If everything's exposed, users tend to wander into parts of the workbook they don't need—and that's usually where mistakes start.

Excel gives you a few ways to reduce that surface area, but it's important to be clear about what they do and don't achieve. For example, "very hidden" worksheets are not a security feature—they won't stop someone who knows where to look. What they do is keep supporting logic out of the way so everyday users don't accidentally interact with it. Think of it less as locking something down and more as tidying it behind the scenes.

Do this: Make the supporting layers "very hidden"

1. Press Alt+F11to open the VBA Editor.

2. Click View > Project Explorerto open the Project Explorer(or press Ctrl+R).

3. Find and select a worksheet you want to hide.

4. Click View > Properties Windowto open the Properties Window(or press F4).

5. Locate the Visibleproperty, and change it to xlSheetVeryHidden.

6. Repeat the process for all supporting worksheets you want to hide, then close the VBA Editor and return to Excel.

Once set, the sheet won't appear, even when you right-click a worksheet tab and select "Unhide," keeping the interface focused on what users actually need to see.

---

Ensure your workbook remains safe while your users stay informed

The 10% rule works best when users only interact with clean outputs. Everything else should remain in supporting sheets, and you can reinforce that structure with a simple README worksheet explaining how the file is meant to be used. That way, collaborators know how to use the workbook without needing to understand how it's built.