Fill Down

March 09, 2013

0 comments

Copy and Paste shortcut   Excel Shortcuts for Mac   Fill Down   Fill Down Shortcut   How Excel Skin Works   Mac Excel Shortcuts   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.

 

Using the "Fill Down" shortcut

Last Monday I re-discovered the fill down shortcut. It's one of the most underrated (and under-used) shortcuts in Excel for Mac. What does it do? It takes the data and/or formula from the active cell, and applies it to the cells in the selected range. Here's how to execute Fill Down: 

Step 1: After navigating to the active cell from which you would like to copy data, hold down shift + down arrow to expand the selection range. 


Step 2: The “Fill Down” shortcut can be found on the “D” key of your Excel Skin, and can be also identified by the large yellow arrow pointing downwards. Since the text is yellow we must look at the modifier keys and find the corresponding yellow text. The “control” key is the only modifier key with yellow, therefore our shortcut is executed by pressing "control" and "D". ⌃D

 

D



The data from the cell above now should be copied into the cell you have selected.


This shortcut saves even more time than the copy-paste shortcuts, and can be lead to a more fluid Microsoft Excel experience. Try the “Fill Down” shortcut in your next spreadsheet and you’ll never stop using it!

Leave a comment

Comments will be approved before showing up.