How would you search an entire workbook with Find & Select?

  • On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Within drop-down to Workbook.
  • On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Look in drop-down to Workbook.
  • On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Search drop-down to All.
  • You cannot search an entire workbook – you must search the worksheets individually.

The correct answer is:

  • On the Home tab, click Find & Select > Find > Options (Windows) or Find & Select > Find (Mac). Change the Within drop-down to Workbook.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers