SheetWhiz brings Trace Precedents, Trace Dependents, Excel shortcuts, and format cycling (similar to Macabacus) to Google Sheets
Google Sheets Excel Shortcuts & Trace Formula Extension
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
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"]}
How to download and manually install Google Sheets Excel Shortcuts & Trace Formula extension for Chrome
Looking for a way to install Google Sheets Excel Shortcuts & Trace Formula extensions for Chrome, you can search for them in the Chrome Web Store, clicking the "Add to Chrome" button, and following the straightforward process.
However, you may need to install Google Sheets Excel Shortcuts & Trace Formula extensions manually, this article outlines two simple methods to effortlessly install Google Sheets Excel Shortcuts & Trace Formula extensions, whether they come as unpacked folders in compressed formats like .zip or as .crx files.
Method 1: Download Google Sheets Excel Shortcuts & Trace Formula extension and manually install through Drag &Drop
If you ever need to manually install a Google Sheets Excel Shortcuts & Trace Formula extension for Chrome, don't worry, it's a simple process. Just follow these easy steps, and you will have your extension ready to use in no time.
Step 1: Download the Google Sheets Excel Shortcuts & Trace Formula Extension by clicking the "Download CRX" button on the website.
Look for the Google Sheets Excel Shortcuts & Trace Formula extension you wish to install. Go to the website and download the Google Sheets Excel Shortcuts & Trace Formula extension package, which is usually a .CRX file and comes in a zipped file. Here ".crx" file is the format for Google Sheets Excel Shortcuts & Trace Formula extension that contains all the data.
Step 2: Extract &Arrange Files
Once the file is downloaded, extract that file into its own folder. Similarly, give that extension files a permanent home. In other words, keep it in a folder that you don't accidentally delete it because these files will be needed to make that extension work.
Step 3: Go to the Chrome Extensions Page
Open Google Chrome and in the address bar, type chrome://extensions; it will open the Google Chrome extensions page. Make sure that "My extensions" is selected in the sidebar.
Step 4: Drag and Drop the Extension
Now, go to the folder where you extracted the Google Sheets Excel Shortcuts & Trace Formula extension and drag &drop the extension file from there anywhere onto the extension page within Google Chrome.
Step 5: Complete the Installation
Once you drag and drop the extension file, follow the steps that Google Chrome takes you through. Similarly, if the extension file is of .crx file format, you will be required to review the permissions and then add the extension.
Now, you can manage that added extension as you would like to with any other Chrome extension that you added through Chrome Webstore. Its icon will also appear in the Google Chrome Menu on the right side of the address bar once you activate it.
Method 2: Download Google Sheets Excel Shortcuts & Trace Formula extension for Chrome and install in Developer Mode
This is another method to install Google Sheets Excel Shortcuts & Trace Formula extension manually, but the twist is that here, you install by enabling the developer mode option provided in Google Chrome. This mode is commonly used for testing extensions or running unpublished tools.
Step 1: Download the Google Sheets Excel Shortcuts & Trace Formula extension file
Select and download the Google Sheets Excel Shortcuts & Trace Formula extension by clicking the 'Download CRX' button on the website.
Step 2: Extract the downloaded contents
Convert the file to a ZIP file if it is in CRX format then extract the Google Sheets Excel Shortcuts & Trace Formula extension zip file or folder that you downloaded. Make sure you extract it using the same folder name and keep it safely in another folder, so you don't delete it by mistake. The extracted folder will be needed to keep your Google Sheets Excel Shortcuts & Trace Formula extension running.
Step 3: Open Chrome Extension Setting Page
In the address bar of Google Chrome, type chrome://extensions and open the Chrome Extension Page.
Step 4: Enable Developer Mode
After opening the Chrome Extension page, look at the top right side, and you will find the toggle option of "Developer mode."Simply enable that developer mode option.
Step 5: Load the Unpacked Extension
Once you enable the developer mode option, you will see the menu of Load Unpacked, Pack Extensions and Update. From that, select the option "Load unpacked."
Step 6: Select the Extension Folder
Once the pop-up opens upon clicking Load unpacked, select the Google Sheets Excel Shortcuts & Trace Formula extension directory and click on the "Select Folder "button.
Step 7: Confirm and Install
After you select an extension folder of a Google Chrome extension you're installing manually, confirm its installation for the final time and let the installation complete.
Conclusion
Here we've made a step-by-step guide on How to manually install Google Sheets Excel Shortcuts & Trace Formula extension in 2 ways. We hope this guide proves helpful.
Similar Extensions
Spreadsheet Shortcuts 8,000+ 9 ★ 96.34KiB
Google Sheets ALT Keys and Trace Formulas 8,000+ 5 ★ 852KiB
Sheets Helper 8,000+ 3 ★ 19.76KiB
Google sheet search 8,000+ 3 ★ 21.19KiB
Excel to Google Sheets 8,000+ 8 ★ 18.74KiB
Add to Sheets - Save to Google Sheets in 1 click 8,000+ 15 ★ 598KiB
AI Excel Bot : ChatGPT Excel Assistant 8,000+ 12 ★ 3.2MiB
Editor for Docs, Sheets & Slides 8,000+ 262 ★ 205KiB
AI Sheets Assistant - For Excel & Sheets 8,000+ 0 ★ 14.99KiB
SheetsGPT - AI Google Sheets Formula Maker 8,000+ 7 ★ 286KiB
Sheets Genie 8,000+ 8 ★ 77.44KiB
ChatGPT Sheets – Use ChatGPT for Sheets 8,000+ 23 ★ 2.09MiB
Converter for Excel 8,000+ 183 ★ 1.78MiB
SheetKeys 8,000+ 13 ★ 47.39KiB
Google Sheets Tabs on top 8,000+ 14 ★ 23.14KiB
Excel Formula Bot Excel Formula Generator AI 8,000+ 2 ★ 276KiB
Sheetgo | Connect, Filter, Merge, Excel, CSV 8,000+ 20 ★ 11.07KiB
Excel Editor Online 8,000+ 7 ★ 713KiB
GPT Formula 8,000+ 1 ★ 172KiB
Templates for Google Sheets™ by cloudHQ 8,000+ 38 ★ 416KiB
GPTSheets 8,000+ 3 ★ 42.58KiB
AI Copilot for Sheets - by Arcwise 8,000+ 23 ★ 1.58MiB
Stopwatch for Google Sheets 8,000+ 5 ★ 5.81KiB
App Script Editor PRO 8,000+ 1 ★ 279KiB
User reviews
Allen Wen (ID: 000000639748e59d) Voted 5 ★ - Updated 11/28/2023
Ender Nova (ID: 000000197753231f) Voted 4 ★ - Updated 09/07/2023
Ally Nabbouh (ID: 000000d8d4db0134) Voted 5 ★ - Updated 04/17/2023
Jeehae Lee (ID: 000000e945ae95c6) Voted 5 ★ - Updated 03/22/2023
Jim Bean (ID: 0000003e49a484b2) Voted 5 ★ - Updated 03/20/2023