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 (lower-right corner).

HELPFUL RESOURCE:

If you like this Excel tip, please share it

Facebook

Twitter

Google+

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:

CTRL + SHIFT + ARROWS: Move/Highlight Cells If you want to quickly move to the last cell of your table/data you can press CTRL + ↔ ↕. If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT + ↔ ↕. Helpful Resource:

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 + F1: Hide/Unhide the Ribbon If you want to have more space in your workbook you can hide the Ribbon menu by pressing CTRL + F1. Another way is to click on the ^ icon which is located on the far right hand side of the Ribbon menu. Helpful Resource: