F4 key on mac for excel

These keys sit at the top of the keyboard and are labeled F1 to F12 on standard keyboards and F13, F14 and higher on extended keyboards. Standard Mac keyboard with 12 function keys. As you know, function keys are uses for many shortcuts in Excel. But if you try these shortcuts directly on a Mac, they don't work. By default, Function keys on a Mac control the computer itself, things like screen brightness, volume, video pause and play, and so on. This means that if press only the function keys in Excel, you'll end up controlling the Mac, and not Excel. To make function keys work like you expect in Excel, you need to add a key: You'll find the fn key in the lower left on your keyboard.

Here are a few examples:. Here you can check a box that will that will change function key behavior to work like "standard function keys".

If you do this, however, note that you won't be able to use function keys for things like Brightness, Volume, etc. In essence, this setting reverses behavior so that you need to use fn to control the Mac. Personally, I like using the function keys to control the computer, so I leave this setting alone, and just the fn key when needed in Excel. Unless you're using an extended keyboard, keys like Home, End, backspace, Page up, and Page down are nowhere to be found. This is a problem, because many of these keys are used in Excel shortcuts.

The solution is to use specific substitutions, as shown in the table below. However, T hey can make some shortcuts seem complicated on a Mac because you have to use more keys.

Keyboard Differences - Switching to the Mac: The Missing Manual, Mavericks Edition [Book]

If you're using an extended keyboard on a Mac, you don't need to worry about substitutions, since you'll have keys for Home, End, Page up, etc. Extended keyboards have all the keys. In the world of shortcuts, perhaps the most painful difference on a Mac is a lack of ribbon shortcuts. In Excel on Windows, you can use so called accelerator keys to access almost every command in Excel using only your keyboard.

This doesn't matter much when you're performing an action that has a dedicated shortcut i.

Download 200+ Excel Shortcuts

But when you want to trigger an action that doesn't have a dedicated shortcut like sort, hide gridlines, align text, etc. For example, Fn turns the key into a Page Up key, which scrolls upward by one screenful. On most Mac keyboards, the Fn key is in the lower-left corner. The exception is the full-size Apple desktop keyboard the one with a numeric keypad ; there, the Fn key is in the little block of keys between the letter keys and the number pad. On the top row of aluminum Mac keyboards, the F-keys have dual functions.

Fixing the F4 Button in Excel for Mac

Pressing the Fn key in the corner changes their personalities, though. Numeric keypad. The number-pad keys do exactly the same thing as the numbers at the top of the keyboard. Apple has been quietly eliminating the numeric keypad from most of its keyboards, but you can still find it on some models. These keys control the brightness of your screen. Tap the key to open Dashboard, the archipelago of tiny, single-purpose widgets like Weather, Stocks, and Movies.

On recent Macs, the F4 key bears a logo instead. Tapping it opens Launchpad, which is described on Launchpad.

• how to convert multiple tiff files to jpeg on mac;
• mac linux usb loader review.
• Toggle absolute and relative references.
• Excel video training?
• how to wipe a hard drive mac os x.
• Keyboard shortcuts in Excel for Mac - Excel for Mac?
• What is Mac equivalent of the F4 shortcut that converts cell - Microsoft Community.

Tap either or to skip to the previous or next track or chapter. Hold one down to rewind or fast-forward. These three keys control your speaker volume. The key means Mute; tap it once to cut off the sound completely and again to restore its previous level. Tap the repeatedly to make the sound level lower, the key to make it louder.

If you hold down the Shift and Option keys, then tapping the volume keys adjusts the volume by smaller increments, just as with the brightness keys. This is the Eject key. Home, End. The Home key jumps to the top of a window, the End key to the bottom. In iPhoto, they jump to the first or last photo in your collection. In iMovie, the Home key rewinds your movie to the very beginning. In Safari, they send you to the top or bottom of the Web page. In Word, they jump to the beginning or end of the line. But then again, Microsoft has always had its own ways of doing things.

On keyboards without a dedicated block of number keys, you get these functions by holding down Fn as you tap the and keys. Pg Up, Pg Down. These keys scroll up or down by one screenful. The idea is to let you scroll through word-processing documents, Web pages, and lists without having to use the mouse. On keyboards without a numeric keypad, you get these functions by pressing Fn plus the and keys.

It closes dialog boxes, closes menus, and exits special modes like Quick Look, slideshows, screen savers, and so on. Get to know it. The Backspace key. This key triggers keyboard shortcuts for menu items. The Control key triggers shortcut menus. In the Finder, Microsoft programs, and a few other places, this key opens up the electronic help screens.