Best Offer for Books in Amazon

Showing posts with label using Find in Excel.. Show all posts
Showing posts with label using Find in Excel.. Show all posts

Friday, 28 April 2017

How to Find a value in Excel Sheet

Find Values :

Hi..Readers in this Tutorial I Will Teach you how to find a value from Excel Sheet. Lets See how to Find a Value in the given Table, Watch the given screen shot.
















in the Home Tab, You can see 'Find' Button , Click there.Now it allows you to Enter your input value in the text box. Type your value(K.Sailaja)  in the text box  and Click 'FIND NEXT' Button.


















It will highlight the location where the word is located.

Now Click 'FIND NEXT' for search next location where it is located.




 Thank you.
Excel Tips

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.