MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcut - Insert Worksheet

August 21, 2017 - by Bill Jelen

Excel Shortcut - Insert Worksheet

Today, a few different Excel shortcuts to insert a new worksheet.

I never knew this one, but it makes sense as a corollary to F11. If F11 inserted a chart sheet, then Shift + F11 inserted a new worksheet.

You can also use Alt + I, W to insert a worksheet, Alt + I, R to insert a row or Alt + I, C to insert a column.

Thanks to Olga Kryuchkova for sending in this idea.

Watch Video

Video Transcript

Learn Excel From MrExcel, Podcast Episode 2135: SHIFT+F11 Inserts A Worksheet.

So, I mentioned yesterday that F11 used to insert a chart sheet. If you would do SHIFT+F11, that will insert a brand new worksheet to the left of the current worksheet. Just a cool little trick that's been around for a long time.

Well, hey. Thanks for stopping by. We’ll see you next time for another netcast from MrExcel.

Title Photo: nataliaaggiato / Pixabay

Bill Jelen is the author / co-author of
Microsoft Excel 2019 Inside Out

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.