SheetWhiz brings Trace Precedents, Trace Dependents, Excel shortcuts, and format cycling (similar to Macabacus) to Google Sheets

Latest Version

Version
1.0.83
Update
October 13, 2024
Size
2.26MiB
Developer
sheetwhiz.com
Category
Users
8,000+
Rating
4.89796 ★
Manifest Version
3
Web Store Status
Languages Support
English (United States)
See more
Permissions
ActiveTab
Identity
Storage
Identity.email
Https://hooks.slack.com
See more

Google Sheets Excel Shortcuts & Trace Formula Extension

➤ Excel Shortcuts on Google Sheets

Love your Excel shortcuts but can’t use them in Sheets? Now you can!

We brought the most frequently used shortcuts to Sheets so you no longer need to click around Sheets to accomplish what you would’ve been able to do with a couple keystrokes in Excel.

Not an Excel junkie? That’s okay too! We’ve defaulted these shortcuts to native Excel, but with SheetWhiz you’re able to customize formatting shortcuts to whatever works best for you. Just click on the shortcut key to modify it

Excel shortcuts are supported on both Mac and PC. ALT is replaced with Option on a Mac. CTRL on a PC maps to Control on a Mac (not Command)
• For shortcuts starting with ALT, press and release all keys in the order listed
• For shortcuts starting with CTRL, press all keys in the order listed and hold down until all keys have been pressed

➤ Trace Precedents on Google Sheets: Get Your Formulas Right

• See all the cells referenced in your formula in one window
• Quickly jump to every precedent cell using the up / down arrow keys
• Make spreadsheet edits without having to close the trace precedents window
• Dive a layer deeper and view the precedents of the precedents cells from the same window without having to rerun the tool. The right arrow key opens and left arrow key closes each layer
• Close the window by hitting \"Esc.\" Never need to touch your mouse!
• Similar to the tracing precedents tools seen in plug-ins like Macabacus, Arixcel, Factset, and S&P Capital IQ on Excel

➤ Trace Dependents on Google Sheets: Modify Your Sheet with Confidence

• See all the cells that reference the cell that you’re on in one window
• Navigate to every dependent cell using the up / down arrow keys
• For large spreadsheets, you can run trace dependents on specific tabs to increase the speed of the tool vs. on the entire spreadsheet
• Close the window by hitting \"Esc.\" Never need to touch your mouse!
• Similar to the trace dependents tools seen in plug-ins like Macabacus, Arixcel, Factset, and S&P Capital IQ

➤ Format Cycling: Be Faster on Google Sheets than Native Excel!

Tired of having to reformat negative numbers as (1) versus the Google Sheet default of -1.00? Need to color code numbers (e.g., Blue = Hard Code, Green = Link, Black = Formula)? Have company colors that you need to use but always need to import them into a Sheet?

Use our format cycles that allow you to quickly flip through number formats, font colors, and cell fills that you define and keep your formatting consistent in every analysis you do

➤ Export Selection as Image (Beta): Keep Your Cell Formatting When Exporting to Slides or Docs!

Ever need to export your analysis into Google Slides or Google Docs? Now you can quickly take a screenshot of your selection by hitting Ctrl + Shift + C. We are working on allowing the image to be updated once it has been pasted - stay tuned!

Our Full List of Customizable Shortcuts:
• Trace Precedents
• Trace Dependents
• Export Selection as Image (Beta)
• Insert & Delete Columns
• All Border Shortcuts (Remove, Bottom, Top, Left, Right, Outside, All, Inner, Horizontal, Vertical)
• Auto-Fit Column Width
• Auto-Fit Row Height
• Set Column Width
• Set Row Height
• Align Center, Left, Right, Top Middle, Bottom
• Increase & Reduce Decimals
• Add & Remove Filters
• Paste Special (Formula, Format, Value, Transposed, Column Width Only, All Except Borders)
• Show / Hide Gridlines
• Increase / Decrease Font Size
• Set Font Size
• Set Font
• Freeze / Unfreeze Rows & Columns (including together at the same time!)
• Merge / Unmerge
• General Number Cycle
• Percent Cycle
• Local Currency Cycle
• Multiples Cycle
• Font Color Cycle
• Cell Fill Cycle

When you install SheetWhiz, you’ll automatically be enrolled in our 21-day free trial of our Pro plan. After the trial is over, you’ll automatically be converted to our Free plan, which includes all the key native Excel formatting shortcuts, with the option to upgrade if desired

Finally, we know data privacy matters to you. There is no mechanism at SheetWhiz for us to see, edit, create, delete, or store any of the values in your spreadsheets or Google Drive files. You can view our Privacy Policy at https://www.sheetwhiz.com/privacy-policy and learn about our security controls and architecture by reading our Security Policy at https://www.sheetwhiz.com/security
Read more

Source Manifest.json

{
"update_url": "https://clients2.google.com/service/update2/crx",
"description":"SheetWhiz brings Trace Precedents, Trace Dependents, Excel shortcuts, and format cycling (similar to Macabacus) to Google Sheets",
"version":"1.0.83",
"name":"Google Sheets Excel Shortcuts & Trace Formula",
"manifest_version":3,
"background":{"service_worker":"background.bundle.js"},
"action":{"default_popup":"popup.html",
"default_icon":"icon-34.png"},
"icons":{"128":"icon-128.png"},
"content_scripts":[{"matches":["https://docs.google.com/spreadsheets/*",
"https://docs.google.com/presentation/*"],
"js":["contentScript.bundle.js"],
"run_at":"document_end"}],
"web_accessible_resources":[{"resources":["icon-128.png",
"icon-34.png",
"question.png",
"lock.png",
"LogoGreyBackground.png",
"LogoGreenBackground.png",
"LogoWithNewFeatureGreenBackground.png",
"TPHouse.png",
"content.styles.css",
"popup.html",
"precedents.html",
"dependents.html",
"Logo - Grey Background.png",
"Logo - Green Background.png",
"LogoGreyBackground.png",
"LogoGreenBackground.png",
"TPGreySquare.png",
"TPCloseButton.png",
"https://cdn.jsdelivr.net/npm/toastify-js/src/toastify.min.css",
"https://cdn.jsdelivr.net/npm/toastify-js",
"google-signin.png",
"Montserrat-Light.ttf",
"Montserrat-Regular.ttf"],
"matches":[""]}],
"key":"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAj221z3U8xjJRdMKQ8PtJ+flusr1AZVYmYaGdZqTcXIms6j07jRa7G8GO432eKHqGIc4LWUuOHeRiB8haPfDGnN7IZUrpOGlFS2Tf1HnyQ+79hsmMdfTpbK4lilp43K33VMNKHC6DwHxspTPPLgFSZE4f7Kj6ueyPoJwPu1/WGbaCc7qUArF8BkpmJ3/ZbY8+BDjCV6sJVwjuo2RL2SQgmAN7Mk3tsSF8p35r/FgN5g6hco2W1r54WyF1rR3Az6/z6xJdc+3orkL9Hergl2o/AWz8m21LytXQKTZl76EniZPy2ysI/SkM0TnPBsc0r1mKn3JTkdRbqWZbcF2LoZ27jQIDAQAB",
"oauth2":{"client_id":"509120768285-e3vcat8ls615dtba8b7u76am7v1onn92.apps.googleusercontent.com",
"scopes":["https://www.googleapis.com/auth/userinfo.email"]},
"permissions":["activeTab",
"identity",
"storage",
"identity.email",
"https://hooks.slack.com"]}
Read more

Similar Extensions

icon

Spreadsheet Shortcuts Extension · Productivity 8,000+ 9 ★ 96.34KiB

icon

Google Sheets ALT Keys and Trace Formulas Extension · Productivity 8,000+ 5 ★ 852KiB

icon

Sheets Helper Extension · Productivity 8,000+ 3 ★ 19.76KiB

icon

Google sheet search Extension · Productivity 8,000+ 3 ★ 21.19KiB

icon

Excel to Google Sheets Extension · Productivity 8,000+ 8 ★ 18.74KiB

icon

Add to Sheets - Save to Google Sheets in 1 click Extension · Productivity 8,000+ 15 ★ 598KiB

icon

AI Excel Bot : ChatGPT Excel Assistant Extension · Productivity 8,000+ 12 ★ 3.2MiB

icon

Editor for Docs, Sheets & Slides Extension · Accessibility 8,000+ 262 ★ 205KiB

icon

AI Sheets Assistant - For Excel & Sheets Extension · Productivity 8,000+ 0 ★ 14.99KiB

icon

SheetsGPT - AI Google Sheets Formula Maker Extension · Productivity 8,000+ 7 ★ 286KiB

icon

Sheets Genie Extension · Productivity 8,000+ 8 ★ 77.44KiB

icon

ChatGPT Sheets – Use ChatGPT for Sheets Extension · Productivity 8,000+ 23 ★ 2.09MiB

icon

Converter for Excel Extension · Productivity 8,000+ 183 ★ 1.78MiB

icon

SheetKeys Extension · Productivity 8,000+ 13 ★ 47.39KiB

icon

Google Sheets Tabs on top Extension · Productivity 8,000+ 14 ★ 23.14KiB

icon

Excel Formula Bot Excel Formula Generator AI Extension · Productivity 8,000+ 2 ★ 276KiB

icon

Sheetgo | Connect, Filter, Merge, Excel, CSV Extension · Productivity 8,000+ 20 ★ 11.07KiB

icon

Excel Editor Online Extension · Productivity 8,000+ 7 ★ 713KiB

icon

GPT Formula Extension · Productivity 8,000+ 1 ★ 172KiB

icon

Templates for Google Sheets™ by cloudHQ Extension · Productivity 8,000+ 38 ★ 416KiB

icon

GPTSheets Extension · Productivity 8,000+ 3 ★ 42.58KiB

icon

AI Copilot for Sheets - by Arcwise Extension · Productivity 8,000+ 23 ★ 1.58MiB

icon

Stopwatch for Google Sheets Extension · Productivity 8,000+ 5 ★ 5.81KiB

icon

App Script Editor PRO Extension · Developer Tools 8,000+ 1 ★ 279KiB

User reviews

icon

Allen Wen (ID: 000000639748e59d) Voted 5 ★ - Updated 11/28/2023 Amazing app. Makes working in gsheets tolerable (somewhat) - definitely a "must have" if you spend any time at all modeling or analyzing data! Great trace dependents tool - highly recommend!

icon

Ender Nova (ID: 000000197753231f) Voted 4 ★ - Updated 09/07/2023 Useful extension though it'd be nice to be able to change what colors we can cycle through as I love making my spreadsheets look ✨aesthetic✨

icon

Ally Nabbouh (ID: 000000d8d4db0134) Voted 5 ★ - Updated 04/17/2023 So many great features brought over from excel to call out but the paste special and row/column insert/delete has saved us so much time in modelling and has allowed us to build more reports for non-excel users. Love this product!

icon

Jeehae Lee (ID: 000000e945ae95c6) Voted 5 ★ - Updated 03/22/2023 SheetWhiz is a GAME CHANGER and the best Google Extension I've ever downloaded. You can do the same things you'd do in Excel but in Google Sheets now, including Google Sheet's paste special, resize column, format borders, trace precedents, etc. This tool is brilliant and has saved me a few hours per week. Highly recommend!!!

icon

Jim Bean (ID: 0000003e49a484b2) Voted 5 ★ - Updated 03/20/2023 Models and analysis are harder in Google Sheets without my shortcuts! The Paste Special pop up with paste formulas, values, formatting = huge!