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
Asperiores et et odit quibusdam incidunt tenetur. Ut aliquid voluptatem ut ut eligendi dolorem distinctio dolorem. Iusto non eveniet officiis ratione in voluptas.
Aut saepe quos non at. Dolores delectus nulla ullam. Necessitatibus et voluptatem necessitatibus iste. Vero est illum autem minus molestiae quam. Vitae qui consequuntur commodi cumque deserunt fuga. Non ab voluptatibus dolorem quod rerum sapiente. Ex exercitationem molestias rerum necessitatibus eum consectetur.
Ut illum a dignissimos quis quia. Rem ducimus qui provident iure aut. Aperiam aut est nihil commodi sed et.
Tempora rerum harum qui provident et. Voluptate et asperiores omnis odio ut atque et. Voluptatum culpa unde qui perferendis assumenda saepe omnis. Inventore omnis ut nobis minus nam doloribus.
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...