什么是Google Sheets Excel Shortcuts & Trace Formula？

Google Sheets Excel Shortcuts & Trace Formula是由https://sheetwhiz.com开发的Chrome扩展程序，该扩展的主要功能是“SheetWhiz brings Trace Precedents, Trace Dependents, Excel shortcuts, and format cycling (similar to Macabacus) to Google Sheets”。

扩展截图

下载Google Sheets Excel Shortcuts & Trace Formula扩展crx文件

下载Google Sheets Excel Shortcuts & Trace Formula扩展crx格式的文件，手动将Chrome插件安装到浏览器中，也可以将crx文件分享给朋友，轻松安装Chrome插件。

扩展使用说明

➤ 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
• We've optimized the tool for speed, and if there is a time-out due to the complexity of the spreadsheet, we'll let you know and return anything that we've already found
• 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

Our Full List of Customizable Shortcuts:
• Trace Precedents
• Trace Dependents
• 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, and Right
• Increase & Reduce Decimals
• Add & Remove Filters
• Paste Special (Formula, Format, Value, Transposed)
• 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 & Compliance white paper at https://www.sheetwhiz.com/security (click "Read our Security & Compliance White Paper")

—

About SheetWhiz: We’re a small team based in San Francisco united by the pain of adopting Google Sheets after years of using Excel. Being forced to use Sheets by our respective companies, we experienced firsthand Sheets’s lack of tools & functions as well as its unintuitive shortcuts. We estimate that we lost about ~40% of our spreadsheet productivity moving from Excel to Sheets….and so we decided to do something about it. Our goal is to enable our users to be more productive in Sheets than they are in Excel

Learn more about us and our products at www.SheetWhiz.com. Any questions or feature requests can be sent via our Contact Us form at www.SheetWhiz.com/Contact-Us or by emailing [email protected]

扩展基本信息

名称	Google Sheets Excel Shortcuts & Trace Formula
ID	bfncmfmdadhimlnpeecppaimgmeeppan
官方URL	https://chromewebstore.google.com/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan
简介	SheetWhiz brings Trace Precedents, Trace Dependents, Excel shortcuts, and format cycling (similar to Macabacus) to Google Sheets
文件大小	2.23 MB
安装次数	1,379
当前版本	1.0.64
更新时间	2024-03-01
上架时间	2023-01-08
评分	4.98/5 共44次评分
开发者	https://sheetwhiz.com
电子邮箱	[email protected]
付费类型	free
扩展官网	https://www.sheetwhiz.com
隐私政策页面URL	https://www.sheetwhiz.com/privacy-policy
支持的语言	en-US
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.64", "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\/*" ], "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" ] }