skysuite

Toggle Cell Color

A one-click toggle that hides every cell on the active sheet whose fill color matches a configured "toggle color" by switching it to white, then restores the original color when toggled again.

When to use it

  • Color-coding plug/override cells with a known shade, then hiding them in one click before delivering a model
  • Temporarily "removing" auditor notes from view while keeping them on the sheet
  • Cycling annotated cells in and out of view during a presentation
  • Mass-toggling every cell on a sheet that uses a single color band

How it works

  1. 1
    Click Toggle Cell Color in the More Tools dropdown (default shortcut Ctrl+Alt+Q).
  2. 2
    SkySuite shows a small popup. If no cells are currently toggled off, it offers to Toggle every cell matching the configured color or Pick a color from a cell on the sheet.
  3. 3
    Click Toggle to flip every matching cell to white and remember the addresses inside the workbook.
  4. 4
    Click the button again - the popup now offers to Restore those cells to the saved color.
  5. 5
    Click Pick color from a cell to select a single cell whose fill becomes the new toggle color, saved globally to SkySuite settings.

Tips & shortcuts

  • Toggle state is per-worksheet and persists inside the workbook (custom XML part), so closing/reopening the file preserves the off state.
  • Cells that match the configured color but have no fill (color index xlColorIndexNone) are skipped.
  • The "current" color is global to the SkySuite installation - picking a new color affects every workbook for this user.
  • When a worksheet is deleted, its toggle state is automatically cleaned up the next time you run Toggle Cell Color in that workbook.