应用截图

Google Sheets Excel Shortcuts & Trace Formula截图1
Google Sheets Excel Shortcuts & Trace Formula截图2
Google Sheets Excel Shortcuts & Trace Formula截图3
Google Sheets Excel Shortcuts & Trace Formula截图4
Google Sheets Excel Shortcuts & Trace Formula截图5

详细介绍

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