Saturday, October 11, 2014

Excel quick tip: Search multiple sheets or entire workbook

Excel is very flexible when it comes to search. The standard Ctrl + F will result in searching the current sheet.
To refine where you want to look for results excel allows searching: a selection inside the sheet ignoring the rest of the cells that are not selected, the current worksheet, multiple sheets or the entire workbook.