number search

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Number search

Number search

resolvedResolved · High Priority · Version 2003

Andrew has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Advanced course

Number search

I am trying to search for a number in a large account spreadsheet. However, the number i am looking for is the product of a formula, and therefore does not come up when I use 'ctrl F' to try and find it. How can i search for numbers that are the product of formulas?

RE: Number search

Hi Andrew

Thank you for the question.

When you press ctrl F the Find Dialog box that appears has an Options button that reveals some extra options. The last of these options is "Look in". Drop this list down and select "Values". This will now search the products of formulas rather than the formuas.

I hope that helps

Laura GB


 

Excel tip:

Deleting cells, Rows & columns

place your cursor on a cell, row number or column letter and use CTRL + -.

View all Excel hints and tips


Server loaded in 0.09 secs.