You can also press ⇧ Shift+F11 to create a new sheet in front of the selected sheet. For example, if you have Sheet1 selected and then press ⇧ Shift+F11, a new sheet called Sheet2 will be created in front of Sheet1. On Mac, press ⌘ Command+T to create a new tab.
Press and hold Ctrl/⌥ Opt and click multiple sheets to select them if you want to copy more than one sheet at once.
Click the File tab or Office button and select “Options. " In the “General” or “Popular” tab, find the “When creating new workbooks” section. Change the number for “Include this many sheets. "
