[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • Last Modified:

Ctrl F does not find cells with formula

HI Experts using excel 2010

I am using the Ctrl F to find data text absolute value ok but when the cell is linked to another cell via = sign is does not find it..

What's the work around.
0
route217
Asked:
route217
  • 2
1 Solution
 
Rob HensonIT & Database AssistantCommented:
At the bottom right of the Find window is an Options button.

Click on that and more settings will show. One of the dropdowns gives options for looking in Values or Formulas.

Try with both of those options.

If you have an area of cells selected when using Find, the search will only look in the selected cells. If you want to search the whole sheet ensure only one cell is selected.
0
 
route217Author Commented:
Hanks rob
0
 
Rob HensonIT & Database AssistantCommented:
Glad to help.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now