CTRL + D/R: Copy Down/Right

A quick way to copy whatever is directly above or to the left of you is to press CTRL + D to copy DOWN or CTRL + R to copy RIGHT.

Helpful Resource:

If you like this Excel tip, please share it

Facebook

Twitter

Google+

F4: Repeat Last Action If you want to repeat a previous action, like inserting a column/row, formatting cells, copy & pasting etc, then you can use the F4 keyboard shortcut which will repeat your last action (in most cases). Helpful Resource:

CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press CTRL+SHIFT+L To un-filter, you need to press this shortcut again. I use this shortcut all the time :)

CTRL + SHIFT + END: Select All Your Data When you have lots of data on a workbook and it is spread out over the page with some blank columns or rows, a great way to select and highlight all your data is to use the CTRL+SHIFT+END keyboard shortcut. This will extend the selection to the last used cell on the worksheet ...

CTRL + ENTER: Fill Down If you want to make a change to a cell and reflect that change to a selection of cells, then pressing CTRL + ENTER will fill down or copy your action to the selected cells. Helpful Resource:

CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS

CTRL + D/R: Copy Down/Right

Related Posts

CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS

Leave a Comment Cancel reply

ABOUT ME

SEARCH EXCEL TUTORIALS

CTRL + D/R: Copy Down/Right

Related Posts

CLICK HERE TO SEARCH OVER 300 EXCEL TUTORIALS

Leave a Comment Cancel reply

ABOUT ME

Helpful Excel Resources

Most Popular Posts

COME HANG OUT WITH ME

SEARCH EXCEL TUTORIALS