Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Quickly Inserting a New Worksheet.
Written by Allen Wyatt (last updated October 26, 2019)
This tip applies to Excel 97, 2000, 2002, and 2003
Going through the process of adding a new worksheet to your workbook can sometimes be a drag. The number of menu choices you need to make can really slow you down. If you are on a roll and you don't want to take the time to wade through the menus, you can use a keyboard shortcut to quickly add a new worksheet. If you need to add a new worksheet before the current worksheet, you can do so by pressing Shift+F11.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2142) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Quickly Inserting a New Worksheet.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Moving between to adjacent worksheets is easy; Excel provides a shortcut key to do the trick. If you want to move between ...
Discover MoreYou can protect various parts of your worksheets by using the tools built into Excel. One thing you can protect is the ...
Discover MoreWhen you add a new worksheet to a workbook, it receives a meaningful name such as "Sheet4" or "Sheet17." If you want to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments