Home > Blockchain >  Google Sheets: How to search/filter tabs by part of the name
Google Sheets: How to search/filter tabs by part of the name

Time:05-25

I have spreadsheet with dozens of sheets with long names. It is very hard to find them in the list-menu etc. Is there a way to filter/find by part of the name?

The only way I found is to click Alt / and search for "Go To Range", and then type TheRequestedSheetFullName!A1 and jump. The problem is the names contains few words, and it is hard to hit exactly the correct name (I want filtering/searching by part of the name).

CodePudding user response:

Yes. In the upper left corner of any sheet (to the far left of the formula bar), there is a field that, by default, shows the current selection in the current sheet. However, if you click in that field and start typing part of a sheet name, a list of all sheets that match will appear. You can then just click on the sheet you want from the shortlist that appears. By default, you will be brought to cell A1 of the sheet you select.

CodePudding user response:

You can make a summary, then search with Ctlr F

function listOfSheetsWithLinks(){
  var ss = SpreadsheetApp.getActiveSpreadsheet()
  var summary = ss.getSheetByName('summary')
  summary.getRange('A:A').clear()
  ss.getSheets().forEach((sh,i) => {
    summary.getRange( i 1,1).setFormula(`=hyperlink("#gid=${sh.getSheetId()}&range=A1";"${sh.getName()}")`)
  })
}
  • Related