insert no of worksheets at a time

  • Thread starter Thread starter rajani
  • Start date Start date
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Or Insert | Worksheet once, then [Ctrl]+[y] to add another, and repeating
[Ctrl]+[y] to continue adding as many as desired.
 
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 said:
Or Insert | Worksheet once, then [Ctrl]+[y] to add another, and repeating
[Ctrl]+[y] to continue adding as many as desired.

Sandy Mann said:
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
Click to expand...
 
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)
 
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
 
Back
Top