Look Who it Was Random video

Excel - Shift F11 Inserts a Blank Worksheet - Episode 603

366 views · Published 7 April 2009 · 2:06 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel - Shift F11 Inserts a Blank Worksheet.
 
Welcome back to the MrExcel netcast! I'm Bill Jelen, and I started this netcast at the suggestion of Leo Laporte. He thought it would be great to have an Excel podcast, and I couldn't agree more. When I first started looking for other podcasts on iTunes, I came across one called the 2-minute Photoshop podcast. However, I quickly realized that the episodes were much longer than 2 minutes, and it got me thinking about the length of my own netcast.

In yesterday's episode, the question from Rod went on for almost 5 minutes. If this is your first time watching, I promise that most of the time, I will keep it to 2 or 3 minutes. But every now and then, we may have a more complicated topic that requires a bit more time. Today, however, I have a quick and simple tip for you, since it's Friday.

Have you ever needed to make copies of a worksheet? My usual trick is to hold down the Ctrl key and click and drag the worksheet to make a copy. But sometimes, you just need a brand new worksheet. Instead of going through the process of inserting a new worksheet, there's a faster way. Just hold down the shift key and hit F11. This will quickly insert a new worksheet for you. And if you need multiple new sheets, just hold down shift and hit F11 multiple times.

So next time you need a new worksheet, remember this shortcut and save yourself some time. Thanks for stopping by, and we'll see you next time for another netcast from MrExcel. Don't forget to like and subscribe for more Excel tips and tricks!

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 MrExcel netcast
(00:18) Inspiration from Leo Laporte
(00:28) Frustration with other podcasts
(00:43) Acknowledgement of longer episodes
(00:56) Simple tip for Friday
(01:06) Making copies of a worksheet
(01:19) Inserting a new worksheet
(01:29) Fast way to add multiple new sheets
(01:41) 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:
2-minute photoshop podcast
Adding new sheets in Excel
Ctrl key in Excel
Excel podcast
Excel shortcuts
Excel tips and tricks
Fast way to insert worksheets in Excel
Inserting new worksheets in Excel
Making copies of worksheets
MrExcel netcast episodes
Shift key in Excel

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



Add new worksheets in seconds. Episode 603 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