Dec 20, 2010 - If you know from the start that you'll want to do a batch Find/Replace. You have to memorize another keyboard shortcut ( command-shift-H ). And unexpected quirks in the general Mac OS X user experience. “Advanced Find and Replace” — with the “Current Document Down”. December 2010. Step 1: In Word 2007/2010/2013, click Home > Replace to open the Find and Replace window; Alternatively, you can using shortcut by pressing Ctrl + H to open the Find and Replace window. Step 2: Click More button to bring up more Search Options; Step 3: Place the cursor in the Find what box, and select Paragraph Mark from the Special drop-down list.

When Microsoft released Office 2007, it changed the way that users search for words or phrases within documents. The standard Find dialog – both the ribbon-based button Home Editing Find, and the Ctrl+F keyboard shortcut – was eclipsed by the new Navigation pane, since there’s almost nothing in the old Find dialog that the new Navigation pane doesn’t do better. The dropdown on the Find box allows access to all the options, such as wild cards, case sensitivity, find in tables, footnotes and comments, and much more. The Navigation pane finds as you type, highlights all occurrences in the text, and shows you snippets surrounding each result so that you can hop between them far more easily than with the old-fashioned Find Next button. If you’re a long-term user of earlier versions of Word, searching with the Navigation pane may be different from what you’re used to If you habitually use Ctrl+F to find text, you’ll appreciate the ability to stick with the keyboard rather than having to reach for the mouse. Pressing Enter from the Find box in the Navigation pane selects the first result and pressing Enter again selects the next result (sorry, it’s no longer Ctrl+PageDown, which Word 2003 and earlier versions used for Find Next). If you want to find something else, press Ctrl+F again.

This enables you to find text and cycle around the results using only two keys. To jump from a selected result in the Navigation pane to the point it refers to in the document text, press Shift+F6, which is the standard keyboard shortcut to switch panes cycling backwards. F6 cycles forwards through all the available panes, which include the ribbon and status bar as well as the document itself and any task panes. To close the Navigation pane, you can press Alt+W, K, the keystroke to toggle the Navigation pane on and off. Even though the Navigation pane can do everything the old Find dialog did, some people still don’t like it. The old Find dialog is still there, now called 'Advanced Find', and you can access it from the Navigation pane, either by clicking the dropdown arrow in the search box, directly from the ribbon via Home Editing Find Advanced Find, or by pressing Alt+H, F, D, A. You can also get to it from the Replace dialog (Ctrl+H) by pressing Alt+D, but none of these methods will do you much good if your fingers keep straying to Ctrl+F whenever you want the old dialog.

In the previous version of excel for mac that I used to use before we 'upgraded' to 365, this would then replace every occurrence of D$34 within the selected cells, as you would expect. However now excel decides to unselect my selection, go to the first cell containing D$34, and only replace it with C$34 in that cell. To show the Formula Bar, click the View tab, and then click to select the Formula Bar check box. Tip: If you want to expand the Formula Bar to show more of the formula, press CONTROL+SHIFT+U. If the above step doesn't work, make sure the sheet is enabled to show formulas.