Maybe you have something better? Ctrl+Alt+Shift+T. To use the keyboard shortcut Ctrl+G, press and hold either Ctrl key on the keyboard and while continuing to hold, press the "G" key with either hand. What’s a fast way to get to C200 and then back to B5? Ctrl+G. But the good news is that Ctrl+G is arguably the fastest way to get back. Ctrl+G in Excel and other spreadsheet programs. REAPER - … Below is the pop-up I get after I go from B5 to C200 using Ctrl+G. Why? Because once you hit Ctrl+G again, it automatically assumes you want to go back to the last cell you were in. You can check for cells with formulas, comments, and more. Shift+F10. In Chrome, Firefox, and Opera, pressing Ctrl+G advances to the next result in the find results. If you’re inspecting a bunch of formulas, you can just keep doing this for each formula. Read row header. So going back using Ctrl+G is fast. So you can toggle back and forth between your formula cell and your precedent cell using Ctrl+[ and Ctrl+G. Why? Now, if you use Ctr+[ and it selects multiple precedents on your current worksheet, you can actually rotate among them with the Tab (or Enter) key. Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200. Because in some cases the default return cell will change to one of the new cells you moved around into, so you’ll have to manually enter the cell you want to return to, or click on it in the list of recently visited cells. Read column header. Selecting this, Excel will only leave highlighted the cells meeting that criteria. QuickBooks Desktop - If you are in a register for an account, entering Ctrl + G will take you to the register for the "transfer" account associated with the line you have selected. Scroll to C200 and then scroll back. Full list of Excel shortcuts. By keying Ctrl + G, a “Go To” box opens. And in this case, Excel guessed right, thus saving you the hassle of typing in your destination again. And you change an assumption, which in turn changes the result in your precedent cell (whether it’s C200 or some cell in another worksheet). Ctrl+Alt+Shift+End. Clicking “Special,” you see a selection of different cell types which Excel will identify. Read row from active cell. Move to a different worksheet in the workbook. Filed Under: Excel Shortcuts, Navigation Shortcuts Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Selection and Navigation, Your email address will not be published. Therefore, it’s one step instead of two. If this sounds too good to be true, just try it. Kind of slow. Rotating among the cells with the Tab key doesn’t mess up the Ctrl+G sequence of cells (it seems to ignore the Tabbing). (Note: the terminology in the window is confusing, since the destination I’m going to is actually in the Reference box, not the Go To box). Top 10 keyboard shortcuts everyone should know. Below are links to related keyboard key and keyboard shortcut pages. Ctrl+Alt+Shift+Home. Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200. Open context menu. The first time I saw someone doing this in the office I couldn’t believe it. For example, you could press Ctrl+G to open the Go To Line window, type 100, and press Enter to go to the 100th line in the file. For example, if you use Ctrl+F to find text in the browser window, pressing Ctrl+G will advance to the next found result. And Ctrl+G will still take you back where you came from. If you’re doing stuff like this all day long and want to check on your precedents, this is a great way to do it. If you’re in B5, Ctrl+[ will take you to C200 (the precedent, or the referenced cell). Why? Ctrl+Alt+Page Up or Ctrl+Alt+Page Down. In most text editors and IDEs, the Ctrl+G shortcut is used to go to a specific line in the file. Read row until active cell. For formulas with more than one precedent, Ctrl+[ still works — it’s just a little more complicated. I hope the Ctrl+[ / Ctrl+G toggle saves you some time. If so, share it. 3 Ways To Convert Text To Numbers In Excel, Excel Shortcut Bible: Comprehensive Excel Shortcut Book, Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar. Ctrl+[ will select all of the referenced cells — assuming they’re on the current worksheet. You can also press Enter to advance to the next result. Ctrl+Alt+Shift+Page Up. Ctrl+Alt+Shift+H Read column until active cell. You can see that B5 (the last cell I was in) is already populated as the destination. Read column from active cell Outlook 2019 and Outlook 2016 - Set up recurrence for an open appointment or meeting. It will leave out any cells on other worksheets – unless the first cell in the formula is in another worksheet. It saved me a lot of time that very day. Actually, all of the referenced cells will be selected, but you’re only guaranteed to see the first one on your screen, since that’s where your screen view will be taken (and the others may be too far away to see). In that case, it will go to the other worksheet and select only to the first cell on that worksheet (not any more than one cell). Let’s say you have a simple formula in B5. We will find cells with “constants,” that is, hard coded values. For example, you could press Ctrl+G, type n8, and press Enter to move to the N8 cell. Ctrl, G, Go to, Keyboard terms, Shortcut key. Just keep moving to another formula cell and do the toggle. For example, you could press Ctrl+G, type n8, and press Enter to move to the N8 cell. Kind of slow. Maybe your precedent depends on a bunch of math in other cells. Ctrl+G in Excel and other spreadsheet programs. Too damned slow. Ctrl+[ works even if the precedent is in another worksheet. You can always double check what’s in the Reference box before you hit Enter). But is there a faster way to get back than entering C200? Fugedaboutit. They will all stay selected, but you can move among them with Tab. Unfortunately, not all formulas have only one precedent. In Microsoft Excel and most other spreadsheet programs, pressing Ctrl+G opens the Go To window that allows you to go to a specific reference (cell). The best thing is to play around with this to get the hang of it. I ran back to my desk. If the formula you’re working with references more than one cell, then Ctrl+[ will take you to the first one. Then, when you’re done, hit Ctrl+G and it will take you back to your original formula cell. The formula is C200*5. You don’t need to enter a destination. But the good news is that Ctrl+G is arguably the fastest way to get back. On Apple computer keyboards, the Ctrl key is labeled as "control.". You forget what’s in C200, what the formula is there, but you need to know. I just hit Ctrl+G and then Enter (no need to specify a destination). Required fields are marked *. This can save you a ton of time compared to manually moving back and forth between workbooks. Because once you hit Ctrl+G again, it automatically assumes you want to go back to the last cell you were in. Alternatively referred to as Control G and C-g, Ctrl+G is a shortcut key most often used to go to a line or page. Your email address will not be published. In Microsoft Excel and most other spreadsheet programs, pressing Ctrl+G opens the Go To window that allows you to go to a specific reference ( cell ). (Note: if you start moving around between cells before you hit Ctrl+G to go back, then Ctrl+G may not be as fast.