How many Worksheets can I Create within one Workbook? Prior to the release of Excel 2007 users could only create 255 within one workbook. However, since the release of Excel 2007 users can now create as many worksheets within one workbook as the memory of the computer can handle. Even if the user does not have access to one of the newest versions of Excel such as Excel 2007 or Excel 2010, they can still make as many worksheets as they would like, but earlier versions of Excel will require more workbooks.
Easy Worksheet Management _ Right_click on any sheet tab (Sheet1, Sheet2, etc.) for a shortcut menu of worksheet options. This is a quick way to rename, delete, add, apply colors to worksheet tabs, copy, and more. By the way, you can also rename a worksheet by double_clicking on any sheet tab (Sheet1, Sheet2, etc.) to highlight the sheet name. Type a new name and press [Enter]. Tip: avoid ALL CAPS which increases the width of the sheet name and decreases how many worksheets can be displayed in one view.