Ctrl+Shift+Arrow key extends the selection of cells to the last nonblank cell in. Shift+Arrow key extends the selection of cells by one cell. Ctrl+Arrow key moves to the edge of the current data region in a worksheet. And on further investigation nor does PowerPoint 2010, Visio 2010, or Outlook 2010 (I didn’t check all the Office programs). Other useful shortcut keys Move one cell up, down, left, or right in a worksheet. Microsoft Excel 2010 (and likely earlier versions), does NOT have any option available to view existing key combinations or to create your own. I was alerted to this lack because of a comment on one of my blog posts - Ctrl+Shift+C activates the Format Painter in Word, but doesn’t do so in Excel, even though Excel also has the Format Painter function. Or you can modify those that are already assigned in Word (though I wouldn’t advise it, because if you have to reinstall Word or you use someone else’s machine your keyboard shortcuts won’t work the same as the ones you’ve set up for your installation of Word).Īssigning keyboard shortcuts has been a feature in Word for years, and I just assumed that the other Office products would have similar functionality. One of the things I like about Word is that you can specify your own keyboard shortcuts for your macros and for functions that don’t already have a key combination.

Microsoft excel shortcut keys 2013