Clicking on the + near the worksheets tab on Excel 2016 adds a new worksheet to the right of the current worksheet. However, hitting Shift+F11 adds a worksheet to left of the current worksheet. The same happens when you use the ribbon to add a new worksheet (Alt, H, I, S).
How do I make Excel to add a worksheet to the right of the current sheet while using a keyboard shortcut?
2 Answers
You can do this with a VBA macro. This macro will add a new worksheet to the right of the active sheet:
Sub SheetAdder() Dim w As Worksheet Set w = ActiveSheet Sheets.Add after:=w End Sub Once installed, you can assign a shortcut key to it like Ctrl+e
Unfortunately I haven't found a way to do that for a single sheet. But if you want to add 2 sheets to the right of the current sheet then just
- Ctrl+Shift+Page Down, then
- Shift+F11
No need for a VBA script. This also works for more than 2 sheets but the new sheets will be put on the left of the last sheet, because basically it's still Shift+F11 which adds a new sheet to the last selected sheet
