- #GOOGLE SPREADSHEET BUTTON SHORTCUTS HOW TO#
- #GOOGLE SPREADSHEET BUTTON SHORTCUTS MAC#
- #GOOGLE SPREADSHEET BUTTON SHORTCUTS WINDOWS#
You can't apply every type of format from the keyboard, but you can apply some of the text formats you're probably familiar with, like bold, italic, and underline styles. This could mean applying style to the text in cells, or styles like shading and borders to set off those cells from the crowd.
#GOOGLE SPREADSHEET BUTTON SHORTCUTS HOW TO#
How to Format CellsĬell formats change the way that a cell appears. By using this keyboard shortcut, you don't have to hunt through the data to find the edge of the block. This is one of the most important Google Sheets shortcuts because it's significantly faster than scrolling through the dataset. You could jump to the rightmost cell by holding Ctrl / Cmd and pressing the right arrow key. Sheets will take you to the bottom of the data range. To jump to the bottom of a dataset, you could hold Ctrl / Cmd on your keyboard, and press the down arrow. Jump to the last continuous cell in a list by pressing an arrow key while holding the control or command key.
#GOOGLE SPREADSHEET BUTTON SHORTCUTS MAC#
Instead of grabbing my mouse and scrolling through it, I simply held Cmd on Mac and pressed the down arrow to jump to the bottom of the text. In the example below, I've got a lengthy list of data that is almost 2000 rows. This takes you to the edge of the data in the direction of the key you hit.
#GOOGLE SPREADSHEET BUTTON SHORTCUTS WINDOWS#
To do this, hold Ctrl on Windows or Cmd on Mac, and press one of the arrow keys to move in a selected direction. 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. 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)
