WordPress bundle Search & Replace

in work books with lots of data when I’m looking for something I sometimes have trouble finding a specific word or phrase that I know is in there somewhere to find feature can help by searching the workbook for you just click find and select on the ribbon then choose find

and type the word or phrase you’re looking for

when you’re done click find next in the dialog box

if the word or phrase is found the cell containing it will be selected at times you may find that you’ve made a mistake throughout your workbook or you need to swap a certain word or phrase for another word that you can use the replace feature instead I actually need to change the name of this department from accounting to finance

to continue go ahead and click replace and it will jump to the next instance automatically if you want to skip the current instance without replacing it click find next instead

alternatively to replace every instance without having to review each one click replace all

and the entire workbook will be updated

when it comes to using replace although it’s important to remember that it could find matches you didn’t anticipate and might not want to actually change generally speaking you don’t want to use replace all because it doesn’t give you the option of skipping anything you don’t want to change so you should only use this option if you’re absolutely sure that it won’t replace anything you didn’t intend it to

now that you know how to use find and replace you can put this time saving techniques to work in your Excel spreadsheets

in Long documents like this one I sometimes have trouble finding a specific word or phrase that I know is in there somewhere the find feature can help by searching the document for you click the find command on the ribbon

then type the word or phrase you’re looking for

the results will show up in the left Pane and will also be highlighted in yellow

you can use the arrows here to jump to each instance of the word

if it’s worth it appears multiple times you can scroll through a list of the results

at times you may find that you’ve made a mistake throughout your document or you need to swap a certain word or phrase for another four that you can use the replace command instead

I actually need to change the warranty review to the abbreviation Sr

now when you’re ready click find next in the dialog box

then click replace

replace all can save you even more time by changing every instance in the document automatically when it comes to using replace although it’s important to remember that it could find matches you didn’t anticipate and might not want to actually change generally speaking you don’t want to use replace all because it doesn’t give you the option of skipping anything you don’t want to change so you should only use this option if you’re absolutely sure that it won’t replace anything you didn’t intend it to

now that you know how to use find and replace you can put this time saving techniques to work in your Word Documents

in a long presentation like this sometimes I have trouble finding a specific word or phrase that I know is in there somewhere the find feature can help by searching the presentation for you to begin click find on the Home tab

type the word or phrase you’re looking for then click the button that says find next

if the word is found PowerPoint will jump to that slide and select the text for you

if you realize that you’ve made a mistake throughout your presentation or you need to swap a certain word or phrase for another there’s a command for that to just click replace on the Home tab or right here in the dialog box

I just need to change the years in this presentation so I’m going to enter that here

when you’re ready click the replace button

and PowerPoint will replace the word and take you to the next instance automatically you can even use replace all to change every instance at once instead of cycling through them one by one

when it comes to using replace although it’s important to remember that it could find matches you didn’t anticipate and might not want to actually change generally you don’t want to use replace all because it doesn’t give you the option of skipping anything you don’t want to change so you should only use this option if you’re absolutely sure it won’t replace anything you didn’t intend it to now that you know how to use find and replace you can put this time-saving technique to work in your PowerPoint presentations