Duplicate tab shortcut key12/3/2023 ![]() ![]() There might be some special situations where you would want to make multiple duplicates of a sheet.įor example, you might need to make 20 copies of a worksheet to say, track transactions in different locations. Making Multiple Duplicates of a Sheet (Using VBA) Make sure you release the CTRL or Shift key before pressing down the CTRL key again for step 2. If you want to duplicate multiple sheets, you can select the sheets you want to duplicate, and then follow steps 2 to 4. You should now see a duplicate of your selected sheet at the point where you released your mouse button. Release the mouse button once you find the spot where you want the new sheet to go.You should see a small arrow at the top of the tabs indicating the position where the newly duplicated sheet will be placed.Hold down the CTRL of your keyboard and use the left mouse button to drag the tab to the right or left, depending on where you want the new duplicate sheet to go.Select the tab of the worksheet you want to duplicate.It lets you duplicate one or more worksheets without having to involve any menus. Using this Method to Duplicate Multiple SheetsĪfter that, follow steps 1 to 7 shown above. You should now see a duplicate of your selected worksheet created in your selected location.Select where you want the duplicate sheet to go.Make sure the checkbox next to ‘ Create a Copy’ is checked.Select ‘ Move or Copy’ from the context menu that appears. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |