Excel Shortcuts on Google Sheets?
I recently moved from PE into a strategic finance role at a startup (as one tends to do when looking for better work-life balance) and found that my startup only uses Google Sheets. I know Google Sheets sucks but we're forced to use it so looking for a way to use Excel shortcuts on Sheets
Know Sheets has some shortcuts (e.g., borders) but they're different from Excel. And stuff like auto-fit columns doesn't exist - you literally have to click each column
Anyone have a solution? I also used Macabacus when using Excel and a lot of the cycling tools + trace precedents would be great to have
Figured I'd ask here given I know some VC shops use Sheets + there are potentially some folks from startups on here that hopefully have found a workable solution
Hey henryhamada, I swear if I had a silver banana for every lonely thread I posted too I'd be richer than @compbanker ...
More suggestions...
I hope those threads give you a bit more insight.
Update: Found a solution! Given the lack of response on the thread and some silver bananas on my initial question, thought I'd share the tool I found given this may be beneficial to others. It's a Chrome extension called SheetWhiz (just Google it - can't paste links). The tool brings a lot of Excel shortcuts to Sheets, including all the shortcuts you'd want to build a model from scratch - autofit columns, borders, paste special, insert/delete columns, etc. It's still missing some stuff like F5 & delete all, for example, but the basic shortcuts are there
It also has a lot of the cyclings from macabacus (number, color, cell fill). The number formats and shortcuts are also customizable which is great. Trace precedents tool is pretty similar to Macabacus with multi-level viewing. It does take a few seconds to run though which is a bit annoying
Attached is an image of the menu (part of it, there are more shortcuts) so you can get a sense for what shortcuts are avail with the tool. Not the greatest UI but gets the job done
Hope this helps!
Helpful - thanks for sharing, I'll plan to give it a try. Note, you can also enable shortcuts Sheets as well by toggling Keyboard shortcuts on
Help --> Keyboard shortcuts
Maybe you already did this - like you said it's still missing a lot of the functionalities. Definitely doesn't have trace precedents and the cyclings you mentioned above but you can probably use this to fill in any feature gaps that are missing on SheetWhiz
Thanks
Et doloremque nisi debitis aliquid facilis aliquid nihil. Odio accusamus sapiente et ipsa maiores. Et occaecati occaecati consectetur ducimus. Id illum sed qui dolores sed ea ducimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...