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
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.