Stay on top of the latest Microsoft Windows tips and tricks with TechRepublic's Windows Desktop newsletter, delivered every Monday and Thursday. In addition, this every sheet has its own active cell, so you can't use this shortcut to jump to another sheet. Be sure to scroll to the right or down until the active cell is no longer on your screen. If it's visible, the screen doesn't change. You may select a single row or multiple rows horizontally or vertically.
Simply press the key, or keys if you’re working on a Mac, and select the arrow keys in the direction of your selection. When you test this, keep in mind that the active cell shouldn't be visible. This shortcut key makes a precise selection using arrow keys. After losing sight of the active cell, just press + and Excel will return you to the active cell. Most likely, you won't remember the cell reference, but that's Okay because there's a keyboard shortcut for returning to the active cell-from anywhere in the same sheet. Now, if you remember the active cell, you can press +G and enter the cell address or range name and click OK (or press Enter). Of course, you probably remember the general direction of the active cell, but depending on just how far you've wandered, scrolling back to the active cell is probably the least efficient way to get there. Once gates have front row source column selected you can two. Getting back to the active cell might prove more difficult in a large sheet. Excel spreadsheet can copy the row in a link to excel shortcut that intersect the country. A simple scroll up or left will return you to where you were-to the active cell-in a small spreadsheet. There are many ways to navigate a large spreadsheet, but scrolling right or down and losing sight of the active cell is quite common. Some spreadsheets are large and extend well past the right and lower edges of your screen.
0 kommentar(er)
