Save content
Have you found this content useful? Use the button above to save it to your profile.
AIA

Quick navigation aids for Excel

by
11th Aug 2011
Save content
Have you found this content useful? Use the button above to save it to your profile.

Microsoft has created a set of PDF Quick Reference Cards to help users navigate around Excel 2010.

The cards, covering Control key combinations, Function keys and “miscellaneous” shortcuts, were published last month in an announcement on the Microsoft Excel blog.

A companion artice provides more background on keyboard shortcuts in Excel 2010, but the Office team realised it was a bit long to work through when you’re sitting in front of your keyboard. In response to “an overwhelming number of requests” from Excel users, Office.com writer Turi Henderson compiled the shortcuts into three PDF files:

The files have been designed to fit on two sheets of paper - or one if you print on both sides - soyou can print them off the files and keep them by your computer as you work on your spreadsheets.

The idea is to produce similar guides for the rest of the Office suite, once the team has collected more feedback. One quirk uncovered by an Excel user is that the CTRL + SHIFT + ) shortcut to hide columns no longer works - yet CTRL + SHIFT + ( still hides a row, according to Jennifer Deacon.

“That's a known bug, unfortunately,” commented Annelise Wirth.

More Excel navigation guides

Replies (2)

Please login or register to join the discussion.

avatar
By ronplan
12th Aug 2011 17:25

Unhide column heyboard shortcut fix for Excel 2010

Here is a link to the solution on getting the keyboard shortcut working again.

http://www.deaconsulting.co.uk/tag/tutorial/

 

Thanks (1)
Replying to Eddie S:
avatar
By Deaconsulting
30th Sep 2011 12:33

Fixing CTRL + SHIFT + )

Thanks for the link to my site ronplan, having raised the question as to why it didn't work I wanted to try and find out a solution as to the "known quirk". Hope it's of use to someone.

 

Jennifer Deacon

Thanks (0)