XLKeys - Excel Shortcuts, Alt keys, and Trace Formulas for Google Sheets

Description

Bring Excel keyboard shortcuts, formula auditing, Goal Seek, Sensitivity Tables, and formatting tools to Google Sheets. XLKeys brings 70+ Excel keyboard shortcuts to Google Sheets — Alt-key hotkeys, paste special, number formats, borders, plus the analysis tools modelers miss most: Trace Precedents & Dependents, Goal Seek, Sensitivity Tables, and one-keystroke Auto-Color. Your Excel muscle memory, working natively in Sheets. No new shortcuts to learn — press the keys you already know (Ctrl on Windows, Cmd on Mac) and they just work. ━━━━━━━━━━━━━━━━━━━━ KEYBOARD SHORTCUTS ━━━━━━━━━━━━━━━━━━━━ The Excel formatting and navigation shortcuts you reach for every day: • Alt-key sequences / hotkeys — Excel's full Alt+H, Alt+E, Alt+A, Alt+W key chains work just like the ribbon (use Option on Mac) • Paste Special — values only, formulas only, formatting, transpose, column widths, all-except-borders (Alt+E,S,V works!) • Insert / delete rows and columns in one keystroke • Number formats — %, $, date, time, accounting, scientific + a customizable format cycle (Ctrl+Shift+1) • Borders — top, bottom, outside, all, thick, double-bottom subtotals, remove • Font & fill color cycling through your modeling palette • Alignment, indent cycle, merge, text rotation, freeze panes, gridlines • Filters, decimals, row/column resize and autofit Every shortcut works on Mac and Windows, and every one is remappable in the Options page. ━━━━━━━━━━━━━━━━━━━━ FORMULA AUDITING ━━━━━━━━━━━━━━━━━━━━ The tools financial modelers need that Sheets doesn't ship with — like having FactSet or Macabacus inside Google Sheets: • Trace Precedents (Ctrl+Shift+[) — see every cell a formula reads from, across sheets, and jump to any of them. Jump back with one key. • Trace Dependents (Ctrl+Shift+]) — see every cell that depends on your selection before you change it • Auto-Color — instantly color-code your model: blue hardcodes, black formulas, purple same-sheet refs, green cross-sheet refs. Colors are customizable. ━━━━━━━━━━━━━━━━━━━━ ANALYSIS TOOLS ━━━━━━━━━━━━━━━━━━━━ Excel's What-If toolkit, finally in Sheets: • Sensitivity Tables — fill an Excel-style two-variable data table right in your sheet (Alt+A,W,T) • Goal Seek — solve for the input that makes a target cell hit a specific value (Alt+A,W,G) ━━━━━━━━━━━━━━━━━━━━ WORKBOOK PERFORMANCE ━━━━━━━━━━━━━━━━━━━━ Cell Capacity Audit Manage the Google Sheets 10 million cell limit. See allocated cells, remaining capacity, workbook utilization, and oversized sheets, then find trailing blank rows and columns to reduce spreadsheet size and prevent “too many cells” errors. Performance Audit Find likely causes of slow Google Sheets workbooks. Scan formulas for open-ended ranges, IMPORTRANGE, volatile functions, INDIRECT, OFFSET, large arrays, repeated lookups, REGEX processing, and deeply nested formulas, with ranked recommendations and sample cells. ━━━━━━━━━━━━━━━━━━━━ WHO IT'S FOR ━━━━━━━━━━━━━━━━━━━━ Investment banking, private equity, FP&A, consulting, accounting — anyone who learned Excel first and now lives in Google Sheets. Whether your just want faster Google Sheets shortcuts or want to feel parity to excel, this is for you! ━━━━━━━━━━━━━━━━━━━━ PRIVACY ━━━━━━━━━━━━━━━━━━━━ XLKeys runs entirely inside Google Sheets. Spreadsheet data is only accessed when you trigger a feature that needs it (formula tracing, Goal Seek) — never in the background, and data is NEVER sent to our servers. See the privacy policy for details. ━━━━━━━━━━━━━━━━━━━━ PRICING ━━━━━━━━━━━━━━━━━━━━ • Free: all 60+ formatting, paste special, and navigation shortcuts • Pro: Some formatting, Trace Precedents/Dependents, Auto-Color, Workbook health, Goal Seek, and Sensitivity Tables • Every signup gets 30 days of Pro free — no credit card required Built by someone with a finance background, for people who live in spreadsheets. Questions or feature requests? Visit xlkeyz.com.

Details & SEO