insert no of worksheets at a time
 

how i get more no of worksheets at a time please explain briefly

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

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

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

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

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