4 min read
New in XLKeys: Cell Capacity and Workbook Performance Scans
It is usually obvious when a Google Sheet has a problem. Finding the cause is the hard part. These two new scans are meant to make that easier.
Read guideXLKeys Blog
Excel-speed workflows for Google Sheets
Practical guides for spreadsheet users who want familiar Excel shortcuts, formula auditing, modeling tools, and healthier workbooks inside Google Sheets.
8 min read
Why Is Google Sheets So Slow? (And How to Fix It)
If typing into your sheet has a half-second delay and the green loading bar never goes away, this is for you. The real causes of a slow Google Sheet and how to fix each one.
Read guide5 min read
How to Add ChatGPT to Google Sheets
OpenAI’s official ChatGPT app lives inside Google Sheets and edits your cells for you. It’s decent — here’s how to set it up, where it helps, and where it’ll get you in trouble.
Read guide9 min read
How to Create and Format Charts in Google Sheets
Most Google Sheets charts look cluttered and amateur out of the box. Here’s how to make your charts look clean along with all the problems folks run into along the way.
Read guide5 min read
How to Turn Your Mac Keyboard Into a PC Keyboard
If you switched from Windows to Mac and your muscle memory is fighting you every day, here’s how to fix it.
Read guide4 min read
How to Use Excel Shortcuts on a Mac
Excel on a Mac sucks. Here are some real ways to get your productivity back.
Read guide3 min read
How to Indent Cells in Google Sheets and Excel
Indenting cells is usually the best practice when formatting your model, but it’s way more clicks than it should be. Here’s the native way and a much faster shortcut.
Read guide4 min read
How to Get Excel-Like Shortcuts in Google Sheets
I recently moved from Investment Banking to Strategic Finance and one of the biggest annoyances was losing all the keyboard shortcuts that made me an Excel power user. Here are the two best ways to get them back.
Read guide4 min read
Is There a Macabacus Add-On for Google Sheets?
Short answer: no, but there are some pretty close alternatives.
Read guide8 min read
Google Sheets Formatting Shortcuts for Excel Users: The Complete Guide
Every Excel formatting shortcut I missed when I moved to Google Sheets — fill color, borders, autofit, freeze panes, number formats — and how to get them all back.
Read guide5 min read
How to Trace Formulas in Google Sheets
Google Sheets is surprisingly easier to trace formulas in than Excel, despite its other limitations.
Read guide6 min read
How to Do Sensitivity Analysis and Goal Seek in Google Sheets
There’s no native data table feature in Google Sheets, but it’s still possible!
Read guide5 min read
How to Use Alt Keys in Google Sheets Just Like Excel
Google Sheets doesn’t natively support Alt keys, but there’s a few workarounds to make it work.
Read guide