How to add a 2nd page

Question

Teresa McDonough 0

how do I insert a 2nd sheet with the same format that I have on the first sheet?

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2023-06-22T09:23:12.84+00:00

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Jazmine Brown 0 Reputation points

2023-06-22T11:15:11.6266667+00:00

There is bit confusion for which platform you are talking about as word, excel, frontpage etc... Generally go to file and add new sheet option or you can also right click in sheet and do the same.

2 answers

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2023-06-22T09:23:12.84+00:00

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Jazmine Brown 0 Reputation points

2023-06-22T11:15:11.6266667+00:00

There is bit confusion for which platform you are talking about as word, excel, frontpage etc... Generally go to file and add new sheet option or you can also right click in sheet and do the same.

Answer 1

Dillon Silzer 57,826 Volunteer Moderator

I'd recommend you duplicate the same tab by right click > Move or Copy > Create a copy > OK:

User's image

If this is helpful please accept answer.

Answer 2

Tanay Prasad 2,250

Hi,

This is a very simple way-

Select the first sheet by clicking on its tab at the bottom of the Excel window.
Press and hold the Ctrl key on your keyboard.
While holding the Ctrl key, drag the selected sheet tab to the right of the existing sheets. This will create a copy of the first sheet.
Release the Ctrl key and the mouse button to drop the copied sheet in the desired position.
The newly inserted sheet will have the same formatting as the first sheet.

Best Regards.