how to search in excel for mac without opening the find and replace box

Search In Excel Without Opening The Find And Replace Box Full Keyboard Access

Whenever you can use Tab to advance between fields, you can also hold down Shift when you press Tab to advance focus in the opposite direction.

Power users work their Macs faster than regular folk do for a variety of reasons.

More important than a speedier processor is a speedier computist.

Since your fingers are nearly always on the keyboard, controlling your computer that wayinstead of taking your hands off the keys to control your mousecan put you into the upper echelon of efficient Mac users.

Becoming a mouse-avoiding keyboard junkie is a learnable skill; it requires practice and memorizationespecially muscle memory.

Everyone knows a few keyboard shortcuts (like Command-P for print, or Command-Q for quit).

Mastering more, along with other efficient ways to control your Mac without reaching for the mouse, will help you get your work done faster, leaving more time for Angry Birds.

Since keyboard shortcuts are the most obvious tool in the mouse avoiders arsenal, youll want to nail those down first.

Learn the basics: Command-X, -C, and -V for Cut, Copy, and Paste; Command-W to close a window; and Command-Tab to switch between open applications.

Many Command-Tabbers forget about Command-, which switches through open windows in the current application.

Who among us hasnt ended up with too many windows filled with too many tabs in our favorite Web browser Command- (and its brother that rotates through open windows in reverse, Command-Shift-) is a great tool for navigating all those windows.

If theres a particular menu command that you use frequently, and it either lacks a corresponding keyboard shortcut or you dont like the shortcut thats assigned, you can always customize your own key combination.

Launch System Preferences, go to the Keyboard preference pane, choose the Keyboard Shortcuts tab, and then click on Application Shortcuts.

Then click the Plus button, choose the Application you want to add a shortcut for, type in the menu command, and then select the key combination youd like to use.

Search In Excel Without Opening The Find And Replace Box Full Keyboard Access

While youre on the Keyboard Shortcuts tab, make sure you turn on Full Keyboard Access.

That option lets you use the Tab key to switch keyboard focus between all controls.

As you navigate Web pages, forms, and dialog boxes on your Mac, you can use the Tab key to quickly switch between each field, instead of clicking your mouse in one after the other.

And you can use the Tab key to switch the focus between different buttons, too.

Heres an example.

The Restart button, however, is ringed in blue, which means I can trigger it by pressing Space.

With Full Keyboard Access enabled, I can move the blue ring to the next button by pressing Tab.

Thus, with a quick Power Button-Tab-Space sequence, I can put my computer to sleep in an instantno mouse required.

Bonus pro-tip: Option-Command-Eject also puts your computer to sleep; its one of many advanced keyboard shortcuts Apple details in a knowledge base article on its Website.

How To Search In Excel For Mac Without Opening The Find And Replace Box