Excel - Great Excel Shortcut Keys - Episode 1209

559 views · Published 2 June 2010 · 4:22 · Indexed 26 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

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