Ctrl+Backspace brings active cell into view
Transcript of the video:
Learn Excel From MrExcel, Podcast Episode 2122: CONTROL+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 -- CONTROL+BACKSPACE.
I had never known this until I was working on the book MrExcel XL.
I had people send in their favorite tips and someone sent this in.
I’m like that's amazing.
Even here, if we select CONTORL+SHIFT+DOWNARROW, CONTROL+SHIFT+RIGHTARROW, now we're down looking at the bottom of the screen but the active cell’s way back up there at the top of the screen.
Just simply press CONTROL+BACKSPACE and it comes back into view.
Or, okay, now 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 2010, 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 CONTROL+BACKSPACE to get back up to the top to have that symbol available to you to convert those to numbers.
Alright.
CONTROL+BACKSPACE, beautiful, beautiful trick.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
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 -- CONTROL+BACKSPACE.
I had never known this until I was working on the book MrExcel XL.
I had people send in their favorite tips and someone sent this in.
I’m like that's amazing.
Even here, if we select CONTORL+SHIFT+DOWNARROW, CONTROL+SHIFT+RIGHTARROW, now we're down looking at the bottom of the screen but the active cell’s way back up there at the top of the screen.
Just simply press CONTROL+BACKSPACE and it comes back into view.
Or, okay, now 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 2010, 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 CONTROL+BACKSPACE to get back up to the top to have that symbol available to you to convert those to numbers.
Alright.
CONTROL+BACKSPACE, beautiful, beautiful trick.
I want to thank you for stopping by.
We'll see you next time for another netcast from MrExcel.
