Using your Excel Skin

October 03, 2012

0 comments

Excel Shortcuts for Mac   Excel Skin   How Excel Skin Works   Using Your Excel Skin  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Overview

There are four primary modifier keys: Shift, Control, Option, and Command. The function key, fn, may also be considered a modifier key for our purposes. Descriptive text for keyboard shortcuts is printed in colors that correspond to modifier keys.

Basics

“Edit an Active Cell”. (F2 for PC users) is a simple and useful shortcut on the “U” key. On the Excel Skin, the shortcut key’s text is written in yellow.

Edit Active Cell Shortcut

Looking at the modifier keys, we see that “Control” is also written in yellow.

Mac Excel Modifier Keys

Therefore, we hit Control + “U” to edit an active cell.

Some shortcuts require more than one modifier key. “AutoSum” is written in green.

AutoSum Shortcut for Mac Excel

Looking at the modifier keys, we see that green appears on both the Shift and Command keys. 

To perform an AutoSum function, we hit Shift + Command + “T.”

AutoSum Key Combination Mac Excel

It’s that easy.


Function Keys

Many people find shortcuts involving function keys (F1-F12) to be confusing. This is understandable because function keys are unique in two ways: 1) Function key shortcuts require the user to hit fn in addition to the designated modifier key combination and 2) default operating system shortcuts override certain application shortcuts.

First, note that “Check Spelling” is written in white text on the F7 key.

Check Spelling Shortcut

Unlike the rest of the keyboard, where white text prompts Shift + Control (the two modifier keys with white on them), white text on function keys means you should type fn + F7.

Mac Excel Shortcuts Function Keys

So remember to hit fn when using a function key shortcut.

Second, take a look at the F11 key on which “New Sheet” is written in blue text.

New Sheet Shortcut Mac Excel

Since this is blue text on a function key, we know the key combination is fn + Shift + F11. Try it out. If you did not successfully add a new sheet, then your application windows probably receded towards the corners of your screen. This means that your Mac’s operating system has default shortcuts that are overriding those in Excel 2011. No big deal, you just need to adjust your user settings in System Preferences. For instructions on how to do that, read Setting up your Mac for Excel.



Leave a comment

Comments will be approved before showing up.