Finology
Finology

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More


Case Study:?Cleaning database ? Deleting the errors

?

Application area:?Final Documentation & Reporting

?

Solution:?Go To (Special) ? Formulas with errors

?

Example:

?

?

Step 1:?Select entire data set using Ctrl+A --> Press Ctrl+G together to activate ?Go To? box --> Choose ?Special? button from the ?Go To? box

?

?

Step 2:?Choose ?Formulas? with ?Errors?

?

?

Step 3:?The above mechanism helps select all the cells with errors simultaneously. Pressing < > key will help   the errors in one go.

?

?

?

Watch CA. Rishabh Pugalia?s Excel Videos ??Click Here


 

11 Likes   168 Shares   49002 Views

Comments


Follow


Popular Articles




Follow taxation Exam20 Book Book Book caclubindia books


CCI Articles

submit article

Stay updated with latest Articles!




update