Adding multiple worksheets
CURRENT FUNCTIONALITY
Add multiple worksheets Determine the number or worksheets you want to add. Hold down SHIFT, and then select the same number of existing worksheet tabs that you want to add in the open workbook. Example: If you want to add three new worksheets, select three existing worksheet tabs. Click Worksheet on the Insert menu. FUTURE FUNCTIONALITY Currently if an Excel file has only one worksheet there isn't a way to add multiple new worksheets except one at a time. Maybe when the user clicks INSERT WORKSHEET there is another option for ONE or MULTIPLE and if the user selects MULTIPLE they are prompted to type in the number new worksheets they want added. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
"Craig" wrote in message ... CURRENT FUNCTIONALITY Add multiple worksheets Determine the number or worksheets you want to add. Hold down SHIFT, and then select the same number of existing worksheet tabs that you want to add in the open workbook. Example: If you want to add three new worksheets, select three existing worksheet tabs. Click Worksheet on the Insert menu. FUTURE FUNCTIONALITY Currently if an Excel file has only one worksheet there isn't a way to add multiple new worksheets except one at a time. Maybe when the user clicks INSERT WORKSHEET there is another option for ONE or MULTIPLE and if the user selects MULTIPLE they are prompted to type in the number new worksheets they want added. Add one sheet, then F4 as many more as you want. |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com