Accounting Made Easy

Learn about Xero
MYOB software and more
to improve your accounting process

 

MYOB

Learn about MYOB so you don’t get charged too much for MYOB software

Xero

Find out important information about XERO accounting software

Retail Manager

Find out important accounting information to help your retail business thrive

Small Business

Get information tailored to small businesses and never pay too much again

Are You Ready To Start Managing Your Money?

Blog

Is excel (CTRL + F) saying that it cannot find what you are looking for?

If you have just spent the better part of couple of hours putting together a “you beaut” excel spreadsheet to do something worthy and have just discovered the Excel Find function (CTRL_F) does not seem to work in the way you expect it then chances are that you have employed formula’s in your worksheets.

You have three choices relating to what is searched:

  1. Formulas
  2. Values
  3. Comments

Chances are if you can see a value say, $2.74 and you search for that figure and are unable to find it then you may have “Lookin:Formulas” selected. Simply change to values and excel will then look for values in the cells and not values in formula’s.