Keyboard Shortcuts To Move Between Blocks Of Data In Excel


I’m very keen on Excel keyboard shortcuts, but somehow I’ve never noticed this before: using control plus the arrow keys will jump you to the left, right, top or bottom of a fixed block of data. Very handy for navigating complex spreadsheets.

In the other Office apps (and many other apps generally), Control plus a key jumps either a word at a time (left and right) or a paragraph at a time (up and down). I imagine the equivalent Cmd key shortcuts also work in Office for Mac, but I can’t confirm that directly. For more Excel shortcuts, check out our listing of the six most useful shortcuts.

[via Project Woman]


The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.

Comments


6 responses to “Keyboard Shortcuts To Move Between Blocks Of Data In Excel”

Leave a Reply