MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Ctrl+F for Sheet Names?

April 25, 2017 - by Bill Jelen

Ctrl+F for Sheet Names?

Excel - Can you use the Find dialog to find a worksheet name?

Watch Video

  • Todd is looking for a way to use Ctrl + F Find for worksheet names.
  • Before solving Todd's problem, review the Navigation Worksheet tricks:
  • Ctrl + Click Right Arrow to go to last sheet
  • Ctrl + Click Left Arrow to go to first sheet
  • Right-click in arrow area to bring up a list of sheets
  • But none of that helps if the worksheets aren't in sequence.
  • Solution: Ctrl + G or F5 to open Go To dialog. Type Sheet Name, then !A1 and click OK

Video Transcript

Learn Excel from MrExcel Podcast, Episode 2083: Find Worksheets

Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.  Today, Todd from Indianapolis and I had this conversation last week.  Todd says, “Hey, can you use Ctrl+F to find a worksheet?”  And then Todd wanted to explain that he has 150 worksheets in the workbook.

And the first thing I said, “Well, Todd, you know how to use these things down here and not just- not just Right, Right, Right.  But if you hold down Ctrl and Right, goes all the way to the end or Ctrl and Left, it goes all the way to the end, or right-click and you get a list of all them.  But if you have 150 of them and they're not in order that is a major pain.  It doesn't work.”  Alright, so there's no good way with Ctrl+F to find a worksheet name because yeah, I mean, it's looking for cell values.  <inaudible> you need to press Ctrl+G or F5, that opens the Go To dialog box.  And let's say we're looking forward D286, you can type in D286!A1 like that, and BAM!  It will jump right to that sheet as long as it exists.

Alright, wrap up: Todd is looking for a way to use Ctrl+F, Find for worksheet names.  Before solving Todd’s problem, I reviewed the navigation worksheet tricks Ctrl + click the Right Arrow to move to the last sheet, Ctrl + click the Left Arrow to go to the first sheet or right-click in the Arrow area to bring up a list of sheets.  But none of that helps if the worksheets aren't in sequence and you have 100 of them or 150 of them.  So, use either Ctrl+G or F5 to open the Go To dialog box, type the sheet name then bang, A1.  Bang, !A1 and click OK. 

Alright, hey, I want to thank Todd for giving me that question at our Indianapolis seminar and I want to thank you for stopping by.  We'll see you next time for another netcast from MrExcel.

Download File

Download the sample file here: Podcast2083.xlsm

Title Photo: Pixabay

Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.