Adding Excel Sheets

M

Migi

Hi, ive just registered and hoping for some help please. I am making u
rotas for work on excel and need to add sheets at the bottom (one fo
each week and so on). How do i get the sheets to become automaticall
filled each time i open a new sheet, hence saving me to copy and past
every sheet?

Thanks in advanc
 
M

maybelle

Migi;1600423 said:
Hi, ive just registered and hoping for some help please. I am making u
rotas for work on excel and need to add sheets at the bottom (one fo
each week and so on). How do i get the sheets to become automaticall
filled each time i open a new sheet, hence saving me to copy and past
every sheet?

Thanks in advance
Click to expand...

Would this get you what you need:

Right click on an existing sheet
Select "Move or Copy"
Select the sheet you want to copy
Check the checkbox "Create a Copy"
Click OK

This should result in a sheet with the same data that you already had.

~
 
Top