Auto-Color in Google Sheets
ProWindows
Mac
Finance formatting convention is universal: hardcoded inputs blue, formulas black, links to other sheets green. In Excel, plugins like Macabacus apply it in one keystroke. Google Sheets gives you nothing — every input gets colored by hand.
XLKeys brings auto-color to Sheets. Select a range, press Ctrl + Shift + S, and every cell is classified and colored instantly: formulas black, hardcodes blue, same-sheet references purple, cross-sheet references green.
Excel vs. Google Sheets vs. XLKeys
| Where | Shortcut |
|---|---|
| Excel | Macabacus: Ctrl+Alt+A (no native Excel shortcut) |
| Google Sheets (native) | No keyboard shortcut |
| Google Sheets + XLKeys | Ctrl+Shift+S |
Google Sheets has no auto-color feature at all — coloring inputs blue and formulas black is a manual, cell-by-cell job without XLKeys.
How to use it
- Select the range you want to color-code (or a whole sheet).
- Press Ctrl + Shift + S (⌘ + Shift + S on Mac).
- XLKeys scans each cell and applies the standard convention: formula = black, hardcode = blue, same-sheet reference = purple, cross-sheet reference = green.
- Re-run it any time after editing — the colors update to match the new contents.
Frequently asked questions
Related shortcuts
Make Google Sheets feel like Excel
Install XLKeys to use auto-color and 150+ other Excel-style shortcuts, Alt-key sequences, formula auditing, Goal Seek, Sensitivity Tables, and Workbook Health audits in Google Sheets.