Excel - Great Excel Shortcut Keys - Episode 1209
559 views · Published 2 June 2010 · 4:22 · Indexed 26 October 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Shortcut Keys in Excel. Welcome back to the MrExcel netcast! In this episode, I'm on a quest to find a solution to a common problem faced by many Excel users. But before I reveal the quest, I have some quick tips and shortcut keys to share with you. These are questions that came up during one of my seminars and I thought it would be helpful to address them here. First off, did you know that instead of using the COUNT function, you can use COUNTA to count cells that do not contain numbers? This was a big hit among the attendees. And speaking of quick hits, let's talk about Undo. We all know the shortcut key for Undo is Ctrl+Z, but did you know that Alt+Backspace and Alt E U are also valid shortcut keys for Undo? It's always fascinating to see the different ways people use Excel shortcuts. Moving on to copying and pasting, most people use Ctrl+C and Ctrl+V, but did you know that you can also use Ctrl+Insert to copy and Shift+Insert to paste? This might be a more convenient option for those who are constantly switching between Ctrl and Shift keys. But now, let's get to the big question that came up during the seminar - how to insert a new worksheet using a shortcut key. At first, I thought we could use Alt I W, which is similar to using the Excel 2003 dialog box. But upon further research, I discovered a more efficient solution. Just like how F11 creates a new chart sheet, Shift+F11 is the shortcut key to create a new worksheet. Another option is Alt+Shift+F1, but Shift+F11 seems like a quicker way to go. Now, onto the quest. This came from Brad, who hates using the mouse and relies solely on keyboard shortcuts. He frequently edits cells using F2, but every once in a while, he accidentally hits F1 which brings up Excel help. This drives him crazy because there's no easy way to close Excel help without using the mouse. So his question is, can we change what F1 does? Can we assign it to a macro or make it do the same thing as F2? If you have a solution, shoot me a quick note at [email protected] and you could win an Excel master-pin and be featured on a future podcast. Thank you for tuning in to this episode of the MrExcel netcast. I hope you found these shortcut keys and tips helpful. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time! 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) Quick Hits and Tips (01:00) Strange Shortcut Keys (02:08) The Quest: Changing the Function of F1 Key (04:00) 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: Change F1 function in Excel Copy and paste shortcuts Count cells with no numbers Excel master-pin giveaway Keyboard application tool for Excel Re-route F1 to F2 Shortcut to create chart sheet Shortcut to edit cell comment Shortcut to insert new worksheet Undo shortcut in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152821/ Alternate shortcut keys....other ways to undo. Other ways to copy and paste. How to edit a cell comment. How to insert a new worksheet. And, a quest...how to assign F1 to do F2. Episode 1209 shows you how. Learn Excel 97-2007 from MrExcel.
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920