Back
Excel

What Keyboard Shortcuts Do You Want To See In Excel?

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

About 18 months ago, I wrote a post on keyboard shortcuts:  http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx.  It was a well-read post that generated a lot of comments and a lot of follow-up email.  To this day, I get emails about this post, a number of which have been people asking for an XLS version of this PDF (http://isamrad.com/dgainer/1_02-23-2006.pdf), presumably so folks can layer their own stuff on top.  Accordingly, I thought it was time for a another post on the topic.  Here is a link to the XLS version of the “Excel Keyboard Shortcuts” PDF:  http://officeblogs.net/excel/Charlie_Keyboard_Shortcut_Book.xls.

While I am at it, though, I wanted to do two other things.  First, I wanted to evangelize two keyboard shortcuts that I only recently learned (re-learned, really) – specifically, ALT + =, which inserts an autosum, and second, CTRL + SHIFT + U, which resizes the Excel formula bar (Excel 2007 only).  Both help me keep my hands on the keyboard, which makes things more efficient.

Second, and more importantly, I wanted to folks’ ideas for new keyboard shortcuts.  What Excel action would you like to see a shortcut for?  For example, I think it would be great to have a shortcut that allowed users to clear filters from Autofilter or PivotTables.  Please add your ideas as comments to this post – that will help others see what you are suggesting, and potentially spark some new ideas.

Top