If you have an existing worksheet with all the layout and formatting defined like this…
And you want to create another worksheet with the same layout and formatting, well, there’s no need to recreate from scratch! You can simply duplicate an existing worksheet and have everything dandy as it is. Here’s how you can do it in just two steps!
1. Right-click the tab that you want to duplicate. In this example, right-click the tab name Worksheet_1 and select Move or Copy.
2. Select (move to end) to place the new sheet after Worksheet_1. Then, select Create a copy and click the OK button.
Voila! The duplicated worksheet now contains the exact same table layout and formatting:
