MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - See Hidden Cells

August 30, 2017 - by Bill Jelen

Excel Shortcut - See Hidden Cells

Do you think that you've hidden column G in Excel and no one will ever see it? Watch out for the sneaky person who uses F5 to select cells in the hidden column and then gets the data from the Formula Bar.

You’ve hidden column D, but you need to see what is in D2. Press Ctrl + G or F5 to open the Go To dialog. Type D2 and press Enter. The cell pointer moves to the hidden cell D2 and you can see the value in the formula bar. You can now use the Down Arrow to move within the hidden column D, always seeing the value in the formula bar.

Watch Video

Auto-Generated Transcript

  • 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 59 episodes ago I said that
  • f5 is the most useful useless to high
  • log 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 left square bracket you can use
  • f5 enter to get back 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
  • G 11 like that press ENTER and they take
  • me in all right
  • 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 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 website but they didn't
  • think that that was possible f5 to sneak
  • into a hidden cell I want to thank you
  • for something by will see you next time
  • for another net cast from MrExcel

Title Photo: realworkhard / 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.