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

Watch on YouTube

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