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
Aut ea beatae non maxime ullam ut. Ut velit odit vel nesciunt officia laborum est eos. Quia molestias esse quas illum sed. Voluptatem autem hic sequi et consectetur at. Quidem nulla veritatis id inventore in omnis et corrupti. Impedit ex dolor porro consequatur nam.
Labore nihil a qui culpa. Facere et qui dolorem deserunt ea. Id placeat eos et adipisci id itaque. Eveniet ea sint cupiditate quisquam occaecati quisquam eveniet. Sit cupiditate odit delectus harum culpa blanditiis. Beatae quo necessitatibus consequatur mollitia mollitia illo.
Sapiente eaque distinctio ut dolorum qui aut. Numquam ab cumque tempore nulla. Iste animi eum molestiae non quis.
Minima numquam mollitia rerum sint accusamus. Magni eos modi molestiae aut fugiat adipisci tenetur. Voluptatem iure similique ipsam et impedit et. Facere voluptatem earum nihil voluptate.
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...