MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Active Cell

August 02, 2017 - by Bill Jelen

Excel Shortcuts - Active Cell

Excel - bring the active cell back in to view. It is easy to find that you can no longer see the active cell. This trick will bring the active cell back in to view.

Ctrl + Backspace to go to ActiveCell
Ctrl + Backspace to go to ActiveCell

This is a great trick that I never knew. Say that C1 is the active cell. You’ve used the scroll bars and now you are looking at ZZ999. To bring the window back to encompass the active cell, press Ctrl + Backspace.

There is a different technique if you have one cell selected but managed to use the scrollbars to move the active cell out of view. Simply press the Right Arrow key to bring the window back to encompass the active cell. Then press the Left Arrow key to return to the cell you were in.

Thanks to Olga Kryuchkova, Schmuel Oluwa, Suat M. Ozgur.

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast Episode
  • 2122 ctrl backspace to bring the active
  • cell into view alright you know this
  • happens sometimes we're working up here
  • in cell b11 and for whatever reason we
  • end up scrolling way over and way over
  • now you know we're way out here we had
  • to look at some data or something like
  • that who knows to get back to the active
  • cell I love this one ctrl backspace I
  • had never known this until I was working
  • on the book MrExcel Excel I had people
  • send in their favorite tips and someone
  • sent a zen-like that's amazing even here
  • if we select ctrl shift down arrow ctrl
  • shift right arrow now we're down looking
  • at the bottom of the screen but the
  • active cells way back up there at the
  • top of the screen just simply press ctrl
  • backspace and it comes back into view or
  • how this one you have to go back to
  • Excel 2010 for this one to be relevant
  • this little symbol here for convert to
  • number okay back in 20 110 you had to
  • have the active cell in view in order to
  • see that symbol so if you would select
  • all the way down to the bottom they
  • wouldn't redraw the symbol here like
  • they do in Excel 2016
  • you'd have to press ctrl backspace to
  • get back up to the top to have that
  • symbol available to you to convert those
  • two numbers
  • all right ctrl backspace beautiful
  • beautiful trick I want to thank you for
  • stopping by we'll see you next time for
  • another NetCast from MrExcel

Title Photo: Free-Photos / Pixabay

Bill Jelen is the author / co-author of
Power Excel With MrExcel - 2017 Edition

This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.