Google Sheets Excel Shortcuts & Trace Formula - Chrome Web Store
Item logo image for Google Sheets Excel Shortcuts & Trace Formula

Google Sheets Excel Shortcuts & Trace Formula

sheetwhiz.com
Featured
5.0(

44 ratings

)
ExtensionTools3,000 users
Item media 5 screenshot
Item media 6 screenshot
Item video thumbnail
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 5 screenshot
Item media 6 screenshot
Item video thumbnail
Item media 2 screenshot
Item video thumbnail
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 5 screenshot
Item media 6 screenshot

Overview

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

➤ 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 — 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 info@sheetwhiz.com

5.0 out of 544 ratings

Google doesn't verify reviews. Learn more about results and reviews.

Review's profile picture

Vamsee RavellaJul 16, 2024

Hi, The login button when pulled up in google sheets does not load into a login screen, it's just a dead image. Do you know of any fixes? Thanks!

Replier's profile picture

David PangDeveloperJul 16, 2024

Hey Vamsee, thanks for trying us out! Could you email me at david@sheetwhiz.com? Might be easier to troubleshoot there (can also hop on a call if helpful!) That said - a few general troubleshooting tips for this: 1. Our tool only runs on Google Chrome. If you are using another browser like Arc or Brave, the pop-up has been known to be blocked. Google Chrome can also block pop-ups but I haven't seen this be an issue with Google OAuth 2. The pop-up sometimes appears behind open windows so I would just double check to make sure it's not behind anything 3. If your browser is managed by a Workspace account then there might be a setting preventing OAuth login....but I haven't seen this and if we hop on a call we can test for this by trying to install the tool on a browser not managed by your organization Thanks! David

Review's profile picture

Lucas MillerJun 19, 2024

This is the best extension I've ever used. By a mile. I work in finance and it saves me time every single day. It's so good that it's converted me from a lifelong Excel junkie to a Sheets evangelist. I even recently moved all my clients from Excel to Sheets. Please do yourself a favor and give this a try if you use Sheets.

2 out of 2 found this helpful
Replier's profile picture

David PangDeveloperJun 20, 2024

Thanks so much for the kind words! Glad we're able to be helpful!

Review's profile picture

Conner VickeryMar 13, 2024

As a big data cruncher at work and for my side projects, I've really come to rely on this tool. Working without sheetwhiz would be like riding a bike without pedals at this point.

1 person found this review to be helpful

Details

  • Version
    1.0.77
  • Updated
    July 22, 2024
  • Size
    2.26MiB
  • Languages
    English (United States)
  • Developer
    Website
    Email
    info@sheetwhiz.com
  • Non-trader
    This developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.

Privacy

The developer has disclosed that it will not collect or use your data. To learn more, see the developer’s privacy policy.

This developer declares that your data is

  • Not being sold to third parties, outside of the approved use cases
  • Not being used or transferred for purposes that are unrelated to the item's core functionality
  • Not being used or transferred to determine creditworthiness or for lending purposes

Related

Editor for Docs, Sheets & Slides

4.7(259)

View, edit and select the layout of Google Docs, Sheets, and Slides with an easy access via extension menu

SheetsGPT - AI Google Sheets Formula Maker

5.0(2)

AI extension that uses AI to provide Sheets functions

GPT Formula

5.0(1)

AI tool that generates helpful Excel formulas and Google Sheet formulas.

Sheets Genie

5.0(8)

Turn Google Sheets into a business automation & web scraping powerhouse.

Spreadsheet Formula Generator & Formula Bot

4.4(22)

Free formula generator for spreadsheets. Formula writer & Function creator. Pivot Table, Regex, VBA, Appscript Code Generator.

Spreadsheet Shortcuts

4.1(9)

This extension is used to map keyboard shortcuts to toolbar buttons in google spreadsheets.

Google Sheets ALT Keys and Trace Formulas

5.0(6)

Extension that Enables Excel-style ALT-key Shortcuts for Google Sheets, plus Trace Formulas, Goal Seek, and More

Google sheet search

4.3(3)

Adds a button to search through sheets in google sheet

Sheetgo | Connect, Filter, Merge, Excel, CSV

4.3(20)

Connect Google Sheets, Excel, CSV, BigQuery, Google Docs and Gmail to import, export, merge, split and filter data automatically.

Excel to Google Sheets

5.0(3)

Convert an Excel or CSV file into Google Sheets by dragging and dropping it into your browser

AI Excel Bot : ChatGPT Excel Assistant

2.8(11)

ChatGPT Powered Excel and Google Sheets formula assistant

Sheetsy

5.0(1)

Excel & Google Sheets personal AI assistant. Convert plain English language to formulas on the fly.

Editor for Docs, Sheets & Slides

4.7(259)

View, edit and select the layout of Google Docs, Sheets, and Slides with an easy access via extension menu

SheetsGPT - AI Google Sheets Formula Maker

5.0(2)

AI extension that uses AI to provide Sheets functions

GPT Formula

5.0(1)

AI tool that generates helpful Excel formulas and Google Sheet formulas.

Sheets Genie

5.0(8)

Turn Google Sheets into a business automation & web scraping powerhouse.

Spreadsheet Formula Generator & Formula Bot

4.4(22)

Free formula generator for spreadsheets. Formula writer & Function creator. Pivot Table, Regex, VBA, Appscript Code Generator.

Spreadsheet Shortcuts

4.1(9)

This extension is used to map keyboard shortcuts to toolbar buttons in google spreadsheets.

Google Sheets ALT Keys and Trace Formulas

5.0(6)

Extension that Enables Excel-style ALT-key Shortcuts for Google Sheets, plus Trace Formulas, Goal Seek, and More

Google sheet search

4.3(3)

Adds a button to search through sheets in google sheet

Google apps