top of page
Writer's pictureDavid Pang

Top 24 Google Sheets Shortcuts for Financial Modeling


Google Sheets financial modeling shortcuts improving productivity

There’s thousands of Google Sheets shortcuts, but only a few dozen that matter for financial modeling purposes. I've created a list of the most important shortcuts for Google Sheets for financial modeling below. If you're going to memorize shortcuts - memorize these!


I put together this shortcuts list assuming you will be building financial models in Google Sheets from scratch and that you know most of the "basic" shortcuts like Copy, Paste, Fill Right, and Fill Down.


Financial modeling shortcuts are important to get down because you'll be using these shortcuts A LOT. They are not one-time shortcuts like adding or removing gridlines or even adjusting font height. You only really need to do these shortcuts a few times. The shortcuts I've written below you'll be using tens or hundreds of times in your work and will make you much more productive.


Because not all shortcuts exist in Google Sheets that are necessary for financial modeling, I've included the corresponding shortcut command if you were to leverage SheetWhiz, the Chrome extension that brings Excel shortcuts to Google Sheets. The tool is free to try and available here. Note SheetWhiz shortcuts are fully customizable so I'm just listing the default shortcuts here, but you can change them as needed.


Note: I am showing the Google Sheets shortcuts that are defaults when you open a spreadsheet. You can also enable additional spreadsheet shortcuts by following the instructions here.

Command

Google Sheets Shortcut

SheetWhiz (All are fully customizable)

Insert Columns & Rows

PC: Ctrl + Alt + + Mac: ⌘ + Option + +

PC: Ctrl + Shift + + Mac: Ctrl + Option + +

Delete Columns & Rows

PC: Ctrl + Alt + + Mac: ⌘ + Option + -

PC: Ctrl + Shift + - Mac: Ctrl + Option + -

Autofit Column Width


PC: Alt, H, O, I Mac: Option, H, O, I

Autofit Row Height


PC: Alt, H, O, A Mac: Option, H, O, A

Set Column Width


PC: Alt, H, O, W Mac: Option, H, O, W

Set Row Height


PC: Alt, H, O, H Mac: Option, H, O, H

Top Border

PC: Alt + Shift + 1 Mac: Option + Shift + 1

Alt, H, B, P

Left Border

PC: Alt + Shift + 4 Mac: Option + Shift + 4

Alt, H, B, L

Right Border

PC: Alt + Shift + 2 Mac: Option + Shift + 2

Alt, H, B, R

Bottom Border

PC: Alt + Shift + 3 Mac: Option + Shift + 3

Alt, H, B, O

Outside Border

PC: Alt + Shift + 7 Mac: Option + Shift + 7

Alt, H, B, S

Paste Formulas


Alt, E, S, F

Paste Values

PC: Ctrl + Shift + v Mac: ⌘ + Shift + v

Alt, E, S, V

Paste Formatting

PC: Ctrl + Alt + v  Mac: ⌘ + Option + v

Alt, E, S, T

Align Left

PC: Ctrl + Shift + l  Mac: ⌘ + Shift + l 

Alt, H, A, L

Align Center

PC: Ctrl + Shift + e  Mac: ⌘ + Shift + e

Alt, H, A, C

Align Right

PC: Ctrl + Shift + r  Mac: ⌘ + Shift + r

Alt, H, A, R

Increase Decimal


Alt, H, 0

Reduce Decimal


Alt, H, 9

Hide Columns

PC: Ctrl + Alt + 0  Mac: ⌘ + Option + 0

Coming Soon

Unhide Cells

PC: Ctrl + Shift + 0  Mac: ⌘ + Option + 0

Coming Soon

Merge Cells


Coming Soon

Unmerge Cells


Coming Soon

Search Bar in GSheets

PC: Alt + / Mac: Option + /



96 views0 comments

Hozzászólások


bottom of page