Ctrl+F for Sheet Names?
April 25, 2017 - by Bill Jelen
Excel - Can you use the Find dialog to find a worksheet name?
- 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
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 the sample file here: Podcast2083.xlsm
Title Photo: Pixabay