Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
how i get more no of worksheets at a time please explain briefly
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
Insert Worksheet or right-click on the sheet tab and select Inseet
Worksheet OK -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "rajani" wrote in message ... how i get more no of worksheets at a time please explain briefly |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
Or Insert | Worksheet once, then [Ctrl]+[y] to add another, and repeating
[Ctrl]+[y] to continue adding as many as desired. "Sandy Mann" wrote: Insert Worksheet or right-click on the sheet tab and select Inseet Worksheet OK -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "rajani" wrote in message ... how i get more no of worksheets at a time please explain briefly |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
I should have added that after using Insert | Worksheet once, then you can
simply hold down the [Ctrl] key and just tap the [y] key to insert more worksheets (one for each tap of the [y]). To explain for rajani: [Ctrl]+[y] repeats the last command given - it doesn't actually have anything directly to do with inserting worksheets. But in this case, since the previous command was Insert Worksheet, it just keeps doing that until you give some other command. "JLatham" wrote: Or Insert | Worksheet once, then [Ctrl]+[y] to add another, and repeating [Ctrl]+[y] to continue adding as many as desired. "Sandy Mann" wrote: Insert Worksheet or right-click on the sheet tab and select Inseet Worksheet OK -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "rajani" wrote in message ... how i get more no of worksheets at a time please explain briefly |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
To insert multiple sheets at the same time, you can use code like
Sub InsertSheets() ThisWorkbook.Worksheets.Add Count:=5 End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "rajani" wrote in message ... how i get more no of worksheets at a time please explain briefly |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert no of worksheets at a time
Select the existing sheets.You can do so by right clicking on sheet name and
'select all Sheets'.Then Go to Insert and Worksheet. It will insert as many sheets as you have selected. Anu "rajani" wrote: how i get more no of worksheets at a time please explain briefly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many worksheets can I insert in a workbook | Excel Discussion (Misc queries) | |||
Insert new row in 2 worksheets | Excel Worksheet Functions | |||
Insert a line into all worksheets in one go. | Excel Discussion (Misc queries) | |||
How do I insert something on multiple worksheets in one workbook? | Excel Worksheet Functions | |||
insert from previous worksheets | Excel Worksheet Functions |