Hi

I use Excel 2011 for the MAC so I know there is a quick search function in the top right hand corner of a workbook which enables you to search the entire workbook. This is a great facility.

I appreciate that it is possible to create a search function using excel formulas using SEARCH, RANK, COUNTIF, VLOOKUP and IFERROR combined but i want to avoid doing this.

So is there the equivalent of 'quick search' (not control and find) for Excel 2013 which will search an entire workbook (all worksheets) and if so how do I get to it on the Ribbon?

Thank you for your help.