Back to Blog

October 17, 2026

Odoo Spreadsheets Add a Full Sheet Management Layer With Hidden Tabs, Color Coding, and a Navigation Menu

Odoo expands its built-in spreadsheet module with complete sheet management: a bottom-bar navigation menu listing every sheet, color-coded tabs for visual organization, the ability to hide sensitive sheets from viewers, and drag-to-reorder tab positioning alongside duplicate, rename, and delete actions.

Odoo’s spreadsheet module has been quietly gaining ground as a legitimate alternative to standalone tools for teams already running their business data inside the platform. But one area where it lagged behind was basic sheet management. If you had a workbook with ten sheets, navigating between them felt clunky, and organizing them visually was essentially impossible.

That just changed. The latest update adds a proper sheet management layer to the bottom bar, bringing color-coded tabs, a navigation menu, hidden sheets, and the full set of tab-level actions that spreadsheet users take for granted.

Diagram of Odoo Spreadsheet interface showing color-coded sheet tabs at the bottom bar, a navigation menu listing all sheets including a hidden one, and a right-click context menu with options for delete, hide, duplicate, rename, change tab color, and move

A Navigation Menu That Actually Lists Everything

The bottom bar of an Odoo spreadsheet now includes a menu icon that, when clicked, lists every sheet in the workbook. This sounds trivial until you’ve dealt with a workbook where twenty tabs extend well past the visible area and you’re clicking arrow buttons to scroll through them blindly.

The menu shows all sheets in one view — including hidden ones, which appear grayed out for editors. You can jump to any sheet with a single click rather than scrolling through the tab bar. For workbooks that have grown organically over months (as they always do), this is the kind of navigation improvement that saves minutes every day.

The left and right caret icons flanking the menu button still work for scrolling the tab bar directly. But the menu makes them a fallback rather than the primary navigation method, which is how it should have been from the start.

Color-Coded Tabs for Visual Organization

Every sheet tab can now be assigned a color. The color shows up as a bar along the bottom edge of the tab in the bottom bar, and as a small dot next to the sheet name in the navigation menu. It’s a visual cue, not a functional grouping — there are no color-based filters or folders — but for teams that use spreadsheets with a mix of input sheets, calculation sheets, and summary views, the ability to color-code by purpose makes the tab bar immediately scannable.

Setting a tab color happens through the context menu, accessible by right-clicking the tab or clicking the down-caret icon on it. A row of color swatches appears, and a single click applies the color. No dialog boxes, no extra confirmation steps. It’s the kind of interaction that works precisely because it doesn’t demand attention.

Hidden Sheets for Sensitive or Intermediate Data

This is the standout feature. Editors can now hide sheets from the bottom bar entirely. A hidden sheet disappears from the tab row and becomes inaccessible to viewers — they can’t see it, can’t navigate to it, and won’t even know it exists. Editors still see hidden sheets in the navigation menu, listed in a grayed-out style, and can restore them with a click.

The use case is straightforward. Many business spreadsheets contain intermediate calculation sheets, raw data dumps, or pricing assumptions that are necessary for the formulas to work but shouldn’t be visible to everyone who opens the file. Until now, the only option was to leave those sheets exposed or move the calculations into individual cell formulas, which trades readability for privacy. Hidden sheets solve this cleanly: the data stays in a dedicated sheet, the formulas reference it normally, and viewers see only the polished output.

The access control is role-based rather than password-based. If you’re an editor, you can see and restore hidden sheets. If you’re a viewer, they don’t exist as far as you’re concerned. This maps well to Odoo’s broader permissions model and avoids the awkwardness of sheet-level passwords that everyone shares anyway.

The Full Context Menu

Right-clicking a sheet tab (or clicking its down-caret icon) opens a context menu with the actions you’d expect from a mature spreadsheet application. Delete removes the sheet after a confirmation prompt — no silent deletions. Duplicate creates a copy immediately to the right of the original, which is useful for creating monthly or quarterly variants of a template sheet. Rename makes the tab name editable inline, and double-clicking the tab triggers the same behavior. Move Left and Move Right shift the tab one position, though dragging the tab directly also works and feels more natural for larger reorganizations.

The plus icon on the bottom bar adds a new blank sheet to the right of the currently active one. It’s a small detail — inserting to the right of the active sheet rather than at the end of the tab bar — but it means new sheets appear in a contextually logical position rather than requiring immediate reordering.

Who Gets What

All of the management actions — adding, deleting, hiding, duplicating, renaming, recoloring, and reordering sheets — are available to users with Editor rights. Viewers can navigate between visible sheets using the tab bar, the caret scroll buttons, and the navigation menu, but they can’t modify anything. This split means a team lead can set up and organize a multi-sheet workbook, hide the sheets that aren’t relevant to the audience, and share it knowing the structure will stay intact.

Small Touches That Add Up

The color dots in the navigation menu mirror the color bars on the tabs, so the visual language is consistent whether you’re looking at the tab bar or the menu. Hidden sheets show their “Show” button right in the menu, so restoring one doesn’t require navigating to a settings page. The confirmation prompt on delete protects against accidental loss without introducing a recovery workflow that would add complexity.

None of these features are revolutionary on their own. Every desktop spreadsheet application has had them for decades. But for a browser-based spreadsheet embedded inside an ERP, catching up on these basics matters more than adding flashy features. Teams that use Odoo Spreadsheets for financial models, inventory tracking, or sales forecasting are working with complex, multi-sheet workbooks every day. Giving them proper tools to organize those workbooks is how you keep them from switching back to a desktop application.

Ready to experience Odoo AI?

Join hundreds of teams using DearERP to customize Odoo in minutes, not weeks. Plans start at $29/month.