When you're working in a large spreadsheet, it helps if you can quickly jump to the edge of the data. Here's one of the most important Google Sheets shortcuts that I know: jumping to the end of a row or column. Instead of pointing and clicking from one cell to another, the natural position for using a spreadsheet is to keep your hands on the arrow keys. Press the respective up, left, right, or down arrows to move between active cells. It's not exactly a shortcut, but one key tip to move around inside of a spreadsheet is to simply use the arrow keys on the keyboard to move between cells. When rows and columns meet, cells are formed, and this is where we can store data.Īs you're moving around in a spreadsheet, it's often far easier to use the arrow keys on your keyboard to move between cells easily.
Just in case you aren't familiar with how spreadsheets work, a key to the format are the seemingly-endless sets of rows and columns. I've listed those shortcuts for both Windows and Mac for each of the shortcuts below. If you pick up even a few of the shortcuts in this tutorial, you'll save yourself a lot of time while working.īecause each of these Google Sheets shortcuts take place inside of a web browser, the keystrokes will vary based on the OS you use.
Google sheets shortcuts how to#
In this tutorial, I'm going to showcase some of those Google Sheets shortcuts and help you think about how to use them. You'll be able to maneuver and work in the data easily and quickly. Anything that you can do with a mouse can be done more quickly with a keyboard.Įven though the app lives in a web browser, Google Sheets has no shortage of helpful keyboard shortcuts that make working in it more efficient. It was painful to learn to use the app without a mouse, but I quickly learned that the best way to use a spreadsheet is with your hands on the keyboard. I once took a spreadsheet course in which the first step was unplugging my keyboard.
0 kommentar(er)
