

How to Zoom In / Zoom Out in Google Sheets Using the Ctrl + / Ctrl - Keyboard Shortcut
If you've ever tried to zoom in or out in Google Sheets using your keyboard, only to find nothing happens, you're not alone. For many...
David Pang
Aug 9, 20253 min read
We made trace dependents for Google Sheets 10x faster
We made trace dependents 10x faster on SheetWhiz. One of the biggest points of feedback we get on SheetWhiz is that trace dependents is...
David Pang
Feb 26, 20251 min read


How to Export Google Sheet Outputs as Images You Can Easily Update
With Export Selection as Image, you can export Sheets selections while maintaining formatting and the location Export data seamlessly...
David Pang
Jan 26, 20252 min read


How to Auto Color Cells in Google Sheets (Hardcodes Blue, Formulas Green)
If you spend a lot of time working with huge amounts of data in Google Sheets, you've probably struggled to find which numbers drive the...
Aman Mishra
Jan 2, 20252 min read


The Top 5 BEST Slack Community Channels for Finance Professionals
The Top 5 Best Slack Communities for Finance professionals include Excel at GSheets by SheetWhiz, Off the Ledger by Airbase, FP&A...
Aman Mishra
Jan 2, 20253 min read


Use a Shortcut to Indent Cells in Google Sheets (Alt + H + 6)
In this article, I will show you how to indent cells in Google Sheets with the shortcut Alt + H + 6, which mirrors the native Excel...
David Pang
Dec 4, 20244 min read


How to Add or Remove Gridlines in Google Sheets (4 Methods)
Creating a clean and presentable spreadsheet is good hygiene for anyone, but a requirement for professionals. However, many who are used to Excel's keyboard shortcut functionality struggle to transfer their skills when required to use Google Sheets. One simple Excel keyboard shortcut that is challenging to replicate in Google Sheets is adding or removing gridlines (Alt + W + V + G in Excel). Removing gridlines in particular is a basic and often the first step in creating a cl
David Pang
Jun 3, 20245 min read


How to Use the Right Border Shortcut (Alt + H + B + R) in Google Sheets
Right Border is a great way to visually separate columns in your analysis and is particularly helpful when performing calculations left...
David Pang
Apr 15, 20241 min read


How to Use the Bottom Border Shortcut (Alt + H + B + O) in Google Sheets
Bottom Border is a great way to create headers in your analysis. Whether it's dates of a forecast or categories in a table, Bottom Border...
David Pang
Apr 12, 20242 min read


How to Use the Paste Formats Shortcut (Alt + E + S + T) in Google Sheets
Paste Formats is a powerful tool to help you quickly standardize formatting in your model, improving the trust others will have in your...
David Pang
Apr 10, 20242 min read