Excel - Master Excel Shortcut Keys: Old Favorites and New Tricks! - Episode 393

2,800 views · Published 12 October 2009 · 3:36 · Indexed 10 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel Shortcut Keys: Old Favorites and New Tricks!

Welcome back to another netcast from MrExcel! In this video, we're diving into Excel 2007 and taking a look at some handy shortcut keys. If you're familiar with the old user interface, don't worry - all of the control shortcut keys you know and love still work in Excel 2007. That's right, Ctrl+C for Copy, Ctrl+B for Bold, and so on. No need to panic, your muscle memory will still serve you well in this new version.

But what about the Alt shortcut keys? Well, I have good news for you. In Excel 2007, these still work as well. For example, if you knew the Alt shortcut for Edit, Fill, Justify in Excel 2003, it will still work in Excel 2007. Simply select the data and hold down Alt, and you'll see a box appear at the top of the screen. As you continue to hit the corresponding letters, Excel will perform the command. This is a great way to continue using your old shortcuts in the new version.

Now, let's talk about the ribbon tabs. You may have noticed that I didn't mention the most important tab in Tuesday's video - the File menu. In Excel 2007, this is now located behind a button called the Office button. It may seem like a strange place to put important commands like New, Open, Save, and Print, but that's where you'll find them. Just be aware that the icon for this button may look different depending on which beta version you have. So if you're having trouble finding the Print icon, it may be hiding behind the Office button.

But don't worry, there's an easier way to access all of these commands in Excel 2007. Simply hit the Alt key without any other keystrokes, and you'll see that each ribbon tab has a keyboard accelerator. These will not change, so M will always be for Formulas, H for Home, and N for Insert. And if you hit the N key, you'll see a whole new set of shortcut keys for every single icon on the ribbon. This means that you can now use the keyboard to access every single item in Excel 2007, making your work much faster and more efficient.

So there you have it, Excel 2007 still honors your old shortcut keys and even offers new ones for every single item on the ribbon. Whether you're a shortcut pro or just looking for a faster way to work, these tips will definitely come in handy. Thanks for watching, and be sure to tune in tomorrow for another netcast from MrExcel!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to Excel 2007 and the new ribbon user interface
(00:48) How to use Alt shortcut keys in Excel 2007
(01:39) The File menu in Excel 2007 is now behind the Office button
(02:20) Excel 2007 continues to honor old shortcut keys
(02:30) An easier way to use shortcut keys in Excel 2007
(03:16) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Alt shortcut keys
Column chart
Ctrl+C, Ctrl+B, Ctrl+I
Edit, Fill, Justify
File menu
Formulas, Home, Insert
Keyboard accelerators
Office 2003 access key
Office button
Print icon
Ribbon user interface
Shortcut keys
Shortcut keys for every icon

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152680/



It's another Excel 2007 Thursday. I'll take a look at how your old Excel 2003 shortcut keys continue to work in Excel 2007. Episode 393 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel