Excel - Go To 3000 Columns to Right - Episode 1863
2,216 views · Published 27 February 2014 · 3:19 · Indexed 12 November 2026
Channel: MrExcel.com · 2014 · Education
Microsoft Excel Tutorial: James T asks if the Ctrl+G Dialog Box provides a way to jump 3000 columns to the right. (After all, Column E + 3000 columns is what? AAA? AAB? How would you know?) R1C1 style referencing is one ugly option, but Bill has something easier. Welcome to another episode of the MrExcel podcast. In this episode, we will be discussing a handy Excel tip that will save you time and effort. Episode #1863 is all about using the Go To function to navigate to 3000 columns to the right. Last week, we shared a tip from Mike Girvin in the Dueling Excel podcast, where holding down Shift while pressing Enter in the Go To dialog box generates a more efficient selection. But then, Bob Umlas suggested holding down Ctrl while pressing Enter, which prompted a question from James - can we use the Go To function to go a specific number of columns to the right? In this video, we will explore different methods to achieve this. We will start by using Mike's and Bob's tricks, which work well for a few columns. But what if we need to go 3000 columns to the right? We could switch to R1C1 notation and use the current row and column in square brackets, but this has its limitations. So, we will turn that off and look for a better solution. After some experimentation, we found that using the =OFFSET function in the Go To dialog box can take us to the desired column. However, this may not be the most efficient method, so we are open to suggestions from our viewers. If you have a better way to achieve this, please share it in the comments section below. We would like to thank James for sending in this question and for being a part of our MrExcel community. We hope this tip will help you in your Excel journey. Don't forget to subscribe to our channel for more useful Excel tips and tricks. Thank you for watching and we'll see you in the next episode of the MrExcel podcast. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Using Ctrl+G to Go To 3000 columns to the right (00:16) Using Shift + Enter in the Go-to dialog box (00:41) Demonstrating the use of F5 or Ctrl G (01:00) Using Ctrl + Enter to select multiple cells (01:10) Exploring the use of R1C1 notation (01:46) Turning off R1C1 style (02:25) Using =OFFSET in the Go-to dialog box (02:47) Considering the effectiveness of this solution (02:59) Request for alternative solutions from viewers (03:09) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: A1 style address Ctrl + Enter shortcut Ctrl+G shortcut Excel tips File Options Formulas Go-to dialog box OFFSET function R1C1 notation Shift + Enter shortcut YouTube comments Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153688/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920