Re: copy formula down column without having to drag the corn Other way is write the formula in the first cell, then select that cell and put the cursor in the right down corner of the cell and double click. You should now have the option to open the drop-down list of the cell and choose one of the options. You can copy and paste this cell to other areas of the worksheet, and you can also move your cursor to the bottom right of the selected cell until it changes, and click and drag it to duplicate the contents to all selected cells.

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.

Outlook for mac doesn't allow searches. 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!