Use F5 or Ctrl+G to sneak into hidden cells
Transcript of the video:
Learn Excel From MrExcel, Podcast Episode 2142.
This one is an awesome trick.
I used to hate the F5 dialog box.
Even on this podcast 1500 episodes ago, I said that F5 is the most useless dialog box in the whole world.
I would never imagine using it, it's dead to me, and people wrote in defending F5.
I showed you a couple of episodes ago, after CONTROL+[ , you can use F5, ENTER to get back, but I love this one.
Someone sent us NAME, TITLE, and YEARS OF SERVICE, but, look, it's columns E, F, and H. There's something hidden in G, and of course you know that they have protected this with a password, so I can not unprotect it, but even with it protected, check this out.
I want to use F5 and what I'm interested in seeing is what's there in column G, row 11.
So, I'm going to go to G11, like that, press ENTER, and they take me in, alright?
They don't unhide it but they take me in, and I can see up here that that heading says PAYROLL, and, sure enough, there is payroll data hidden here in all of these cells, and I just use the arrow keys to move throughout that column, and look up in the formula bar, and I can see what's in the hidden cells.
Whoops.
I bet they didn’t think that that was possible: F5 to sneak into a hidden cell.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
This one is an awesome trick.
I used to hate the F5 dialog box.
Even on this podcast 1500 episodes ago, I said that F5 is the most useless dialog box in the whole world.
I would never imagine using it, it's dead to me, and people wrote in defending F5.
I showed you a couple of episodes ago, after CONTROL+[ , you can use F5, ENTER to get back, but I love this one.
Someone sent us NAME, TITLE, and YEARS OF SERVICE, but, look, it's columns E, F, and H. There's something hidden in G, and of course you know that they have protected this with a password, so I can not unprotect it, but even with it protected, check this out.
I want to use F5 and what I'm interested in seeing is what's there in column G, row 11.
So, I'm going to go to G11, like that, press ENTER, and they take me in, alright?
They don't unhide it but they take me in, and I can see up here that that heading says PAYROLL, and, sure enough, there is payroll data hidden here in all of these cells, and I just use the arrow keys to move throughout that column, and look up in the formula bar, and I can see what's in the hidden cells.
Whoops.
I bet they didn’t think that that was possible: F5 to sneak into a hidden cell.
Well, hey.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
