#How ot find and replace on mac how to

Within: allows you to choose to search the entire workbook, instead of a single sheet.

FormatвЂ¦ lets you narrow your search to specific cell formats (weвЂ™ll see shortly how useful this can be).

YouвЂ™ll see a wide variety of new choices. I think I just pulled a muscle.Now that you have basic searching down, letвЂ™s take a look at some of the more advanced options you have for finding data.Д¬lick the Options > button in the Find and Replace dialog. UghвЂ¦it hurts my insides to have to praise Word. I look forward to the day when Pages has as awesome of a вЂњFind & ReplaceвЂќ feature as Microsoft Word, but in the meantime, at least we can strip out a few invisible characters. This feature also seems a bit more persnickety with the new version of Pages than with Pages вЂ™09, and you may not be able to get it to find and replace page or section breaks in that version, just so you know. The shortcut for that is Command-E, so you could press Command-E and then Command-F to pop right into the вЂњFindвЂќ box with the invisible character youвЂ™ve chosen. The only caveat I have is that, if this doesnвЂ™t seem to be working properly for you, try selecting your character and then going up into the menus and choosing Edit> Use Selection for Find. Of course, you wouldnвЂ™t have to paste the two spaces into the вЂњFindвЂќ box-you could just type вЂ™em on in there. IвЂ™ve used this feature in so many handy ways! For example, IвЂ™ve replaced double paragraph breaks in documents (by copying two of them at once and pasting that into the вЂњFindвЂќ box) IвЂ™ve done away with multiple tabs so that I could format a document properly and IвЂ™ve also used it for replacing double spaces. Afterward, you can use the arrow keys at the bottom to step through and choose which ones to replace, or if youвЂ™re feeling brave and are willing to get rid of everything, just press вЂњReplace All.вЂќ ThatвЂ™ll open up a new panel in that window for you to type in.ДЄs IвЂ™ve done above, you can leave the вЂњReplaceвЂќ field blank if you want to remove every instance of the character youвЂ™ve pasted in, or you can type in something different. It looks like nothing is there (at least in the most recent version of Pages), but itвЂ™ll find your pasted tabs or your paragraph returns or what have you.ДЄnyway, then you can click on the gear icon on that window and pick вЂњFind & ReplaceвЂќ if youвЂ™re looking to strip out those characters or change them instead of just looking at them. вЂ¦and then press Command-C (or choose Edit> Copy) to copy it.В Press Command-F (or pick Edit> Find> Find) to start a search, and paste your invisible character into the вЂњFindвЂќ box by clicking in the field and pressing Command-V (or by selecting Edit> Paste). So what youвЂ™ll do here is select the invisible character youвЂ™d like to findвЂ¦ The pedant in me is SO ANGRY just looking at that. ItвЂ™s not cool to try to use tabs to align the text in that way, because if you then make changes that cause the text to reflow, the documentвЂ™s gonna get ugly. Yup, look at those tabs, sticking out there allвЂ¦pointy. But if I go up and pick View> Show Invisibles, I can confirm thatвЂ™s the case. I can tell somethingвЂ™s off because the left margin (indicated by my arrow) is set way over from where the text is, so I figure that whoever wrote this document added in tabs where he wasnвЂ™t supposed to. So first, letвЂ™s take a look at the example text IвЂ™ve got here. Deleting a bunch of tab characters by hand may just be my own personal hell.

As I mentioned, you can see which ones youвЂ™ve got by choosing View> Show Invisibles.Д«ut hereвЂ™s a pickle: What if youвЂ™re editing a document, and you find that its formatting is all messed up because of tons of those invisible characters? Is there any way to do a find and replace on them so that you donвЂ™t have to go through and delete 476 tabs, for example, that were being used to adjust margins incorrectly? I am very thankful that we can do just that.

#How ot find and replace on mac how to

Way back when dinosaurs roamed the earth, I wrote a tipВ about how to recognize invisible characters in Pages and what their silly symbols mean.