11 basic Excel tricks that will change your life

Even regular users of Microsoft Excel might not be getting as much out of it as they can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know.

1. Jump from worksheet to worksheet with Ctrl + PgDn and Ctrl + PgUp

2. Jump to the end of a data range or the next data range with Ctrl + Arrow

Of course you can move from cell to cell with arrow keys. But if you want to get around faster, hold down the Ctrl key and hit the arrow keys to get farther.

3. Add the Shift key to select data

Ctrl + Shift +Arrow will extend the current selection to the last nonblank cell in that direction.

See the rest of the story at Business Insider

See Also:

SEE ALSO: This is what separates the Excel masters from the wannabes

via Business Insider http://ift.tt/28POEtp

Advertisements