Scrolling through hidden worksheets
Hi,
I have a workbook which has many hidden worksheets (roughly 100).
Until recently if I went to unhide the worksheets, I could find the one I was looking for by typing the first letter of the name of the sheet, and then it would automatically scroll through the sheets with the corresponding first letter.
Now if I do this, it only goes to the first sheet with the name starting with the letter, but doesn’t scroll through to the other ones.
Does anyone have an easy solution to filter through the hidden worksheets?
Hi, I have a workbook which has many hidden worksheets (roughly 100).Until recently if I went to unhide the worksheets, I could find the one I was looking for by typing the first letter of the name of the sheet, and then it would automatically scroll through the sheets with the corresponding first letter. Now if I do this, it only goes to the first sheet with the name starting with the letter, but doesn’t scroll through to the other ones. Does anyone have an easy solution to filter through the hidden worksheets? Read More