How Do I Navigate in a Google Sheets Workbook? скачать в хорошем качестве

How Do I Navigate in a Google Sheets Workbook?

How Do I Navigate in a Google Sheets Workbook? Navigating in Google Sheets is similar to Excel and other general software but with some distinct features tailored to its online and collaborative nature. We’ve built this practice sheet for you to work along with us. Get it here: https://www.smallbusinesscoo.com/cont... and watch the whole video here    • 12 SIMPLE, but SUPER HANDY Google Sheets N...   A Google Sheets file is a workbook that contains one or more worksheets (or sheets). Each worksheet consists of a grid of cells organized into rows and columns, where you enter data, formulas, and perform calculations. Rows are labeled with numbers (1, 2, 3, …). As you see on the left Columns are labeled with letters (A, B, C, …). As you see along the top The intersection of a row and a column forms a cell, and each cell has an address, like A1 (column A, row 1), which you use for data entry and formulas. So, lets practice a little bit. We’ve built this practice sheet for you to work along with us. There is a link in the video description where you can get a copy before we continue. In the practice sheet Use your mouse and move your cursor and select different cells in the worksheet like this. But, How Do I navigate without the mouse in Google Sheets? Using the arrow keys you can navigate left, right, up, and down in the sheet. If you hit the enter key it activates the edit of the cell and if you hit enter a second time you’ll move down the worksheet one cell. But, if you hold the shift key and press enter you will go up the worksheet one cell. The tab key will move you to the right. But if you hold Shift and press the tab key you can move left. But did you know that the enter key does something different after you have used the tab key? I am going to fill in 1 in cell b2, press tab, type in 2 in cell c2, press tab, type in 3 in cell d2, and then press enter. What happened? I returned to cell b3 to start typing in the next row. But, let’s enter 1 in cell b5, press tab, type 2 in cell c5, press tab, type 3 in cell d5 and hold the shift key and press enter. What happened? I returned back to cell B4 moving one row above to enter more data. How can I navigate quickly in a table of data? Here in this example we have a table of inventory. You can see the part number, description, cost, quantity, and Inventory Balance. But, this table could be pages long and have way more columns based on your business. So, if you want to move quickly to the bottom of the table from cell B7 hold the CTRL key and press the down arrow. Likewise, if you use the CTRL key and press the right arrow you’ll move to F11 or the right side of the table. Using the CTRL Key and the up and left arrow will continue moving along the edge of the table. But you can use CTRL and the arrows in the middle of the table, too like this. This is good but, How can I navigate quickly around the worksheet? There are a few ways to navigate around the worksheet. With the CTRL key we can quickly move. Right now hold the CTRL Key and press the home key. This shortcut command will always return you to cell A1. But if you want to get to the end of the worksheet hold the CTRL Key and press the end key. Now we are on cell Z1000. Let’s move left by holding the CTRL key and pressing the left arrow and up holding the CTRL key and pressing the up arrow. You can see these commands can help you move through the worksheet fast. But, there are two other ways to move quickly in a worksheet. The page up and page down keys will move you up and down the worksheet. But if you hold the ALT key and press page down you will move right one screen and by holding the ALT key and pressing Page up you will move left one screen. But there is one more way to move around Google Sheets. On the Bottom and Right side of the sheet are scroll bars. Using the Scroll bars you can move up and down, left and right to view the page