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. Kind of slow. Clicking “Special,” you see a selection of different cell types which Excel will identify. 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 ). By keying Ctrl + G, a “Go To” box opens. I ran back to my desk. Rotating among the cells with the Tab key doesn’t mess up the Ctrl+G sequence of cells (it seems to ignore the Tabbing). For example, you could press Ctrl+G, type n8, and press Enter to move to the N8 cell. 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. Your email address will not be published. You can always double check what’s in the Reference box before you hit Enter). (Note: if you start moving around between cells before you hit Ctrl+G to go back, then Ctrl+G may not be as fast. Too damned slow. Top 10 keyboard shortcuts everyone should know. If the formula you’re working with references more than one cell, then Ctrl+[ will take you to the first one. Why? For example, if you use Ctrl+F to find text in the browser window, pressing Ctrl+G will advance to the next found result. Ctrl+Alt+Page Up or Ctrl+Alt+Page Down. Maybe you have something better? It saved me a lot of time that very day. 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. Below are links to related keyboard key and keyboard shortcut pages. This can save you a ton of time compared to manually moving back and forth between workbooks. For formulas with more than one precedent, Ctrl+[ still works — it’s just a little more complicated. 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. 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). Because once you hit Ctrl+G again, it automatically assumes you want to go back to the last cell you were in. But the good news is that Ctrl+G is arguably the fastest way to get back. And Ctrl+G will still take you back where you came from. Selecting this, Excel will only leave highlighted the cells meeting that criteria. Unfortunately, not all formulas have only one precedent. Maybe your precedent depends on a bunch of math in other cells. Because once you hit Ctrl+G again, it automatically assumes you want to go back to the last cell you were in. Full list of Excel shortcuts. The formula is C200*5. It will leave out any cells on other worksheets – unless the first cell in the formula is in another worksheet. Scroll to C200 and then scroll back. You forget what’s in C200, what the formula is there, but you need to know. If so, share it. What’s a fast way to get to C200 and then back to B5? You can also press Enter to advance to the next result. Below is the pop-up I get after I go from B5 to C200 using Ctrl+G. They will all stay selected, but you can move among them with Tab. Read column from active cell 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. (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). Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200. Filed Under: Excel Shortcuts, Navigation Shortcuts Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Selection and Navigation, Your email address will not be published. Ctrl+Alt+Shift+T. Ctrl+Alt+Shift+Home. Why? Let’s say you have a simple formula in B5. 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. Required fields are marked *. We will find cells with “constants,” that is, hard coded values. Read row until active cell. So going back using Ctrl+G is fast. Just keep moving to another formula cell and do the toggle. You don’t need to enter a destination. If you’re inspecting a bunch of formulas, you can just keep doing this for each formula. 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). Ctrl+G in Excel and other spreadsheet programs. Outlook 2019 and Outlook 2016 - Set up recurrence for an open appointment or meeting. I hope the Ctrl+[ / Ctrl+G toggle saves you some time. But the good news is that Ctrl+G is arguably the fastest way to get back. You can see that B5 (the last cell I was in) is already populated as the destination. Ctrl+Alt+Shift+End. In most text editors and IDEs, the Ctrl+G shortcut is used to go to a specific line in the file. 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). For example, you could press Ctrl+G, type n8, and press Enter to move to the N8 cell. Read row header. So you can toggle back and forth between your formula cell and your precedent cell using Ctrl+[ and Ctrl+G. If you’re in B5, Ctrl+[ will take you to C200 (the precedent, or the referenced cell). Ctrl+G in Excel and other spreadsheet programs. If this sounds too good to be true, just try it. Ctrl+[ will select all of the referenced cells — assuming they’re on the current worksheet. Ctrl+[ works even if the precedent is in another worksheet. Hit Ctrl+G (or F5), and then type C200 (and then Enter) to go to C200.