Applying Formats to Cells with Shortcuts

July 16, 2013

0 comments

applying currency format   Applying Number Format   Excel on Mac   Excel Shortcuts for Mac   Format   Format Cells   formatting   Formatting Cells   Formatting number cells  



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.

 

5 Shortcuts to Applying Formats

Instead of just one shortcut this week we are going to cover five simple shortcuts.  These shortcuts will save you a lot of time when you are trying to apply a specific format to a cell. 

 

Shortcut #1: Applying the time format

Shortcut #2: Applying the date format

Shortcut #3: Applying the general number format

Shortcut #4: Applying the percentage format

Shortcut #5: Applying the exponential number format

 

Step 1: As with most shortcuts in MS Excel for Mac you must have an active cell, which you wish to manipulate.  The format shortcuts are unique in the sense that you do not need data in the cell already.  Once you execute the shortcut, which applies a format, any data entered into the cell will adopt the format you have entered.

  

Step 2: Now we must execute the shortcut.  All five of these shortcuts have the same modifier keys: “control” + “shift”.   

 

Shortcut #1: Applying the time format

 

Shortcut #2: Applying the date format

 

Shortcut #3: Applying the general number format

 

Shortcut #4: Applying the percentage format

 

Shortcut #5: Applying the exponential number format 

 

 

 

I have applied the five formats to the cells directly under their labels:

 

 

Step 3: Inserting data into the formatted cells.   

Now that you have formatted the cell to your desired format, you must enter the data.  

*Note: you must enter data in the same format as you want it to appear.  For example the raw data I am entering into these cells are:

2:30 for Time

1/15 for Date

77 for Number

77 for Percentage

77 for Exponent

 

And my results:

 

 

Now instead of right clicking, choosing Format Cells, and having to riffle through the options in the Format Cells dialog box, you can quickly apply these five pre-programed formats to any cell with the tap of three keys.  

 



Leave a comment

Comments will be approved before showing up.