Forum Discussion
Copying connected sheets
Hello,
One last question from me as my project is almost finished. Thank you to those who have helped me over the last couple of days.
As I mentioned before, I am a teacher and I have made two sheets (focussing on maths) that are connected by various formulas (see screenshot below). These are now my templates to work with this year.
I want to copy these sheets to make the same templates for English and all the other subjects that I teach. Obviously it's really important to maintain the connected formulas across the pair of sheets. Can anyone tell me how to do this please?
Apologies if I'm not using the correct terminology!
Thank you,
Susie
Click on the first of the two sheet tabs.
Hold down Ctrl while you click on the second of the two sheet tabs.
You have now selected both sheets.
Option 1: Drag one of the selected sheet tabs to the right (the other will come with it). Before you drop it, press and hold Ctrl.
Option 2: Right-click any of the selected sheet tabs.
Select 'Move or Copy' from the context menu.
Tick the check box 'Create a copy'.
Select '(move to end)' in the 'Before sheet' list box.
Click OK.
Both options will copy both sheets, and adjust the formulas linking them correctly.
Important: before you enter anything in the copied sheets, either click on another sheet tab, or right-click on one of the selected sheet tabs, then select 'Ungroup sheets' from the context menu.
If you forget to do that, anything you enter will be entered on both sheets at the same time.
2 Replies
Click on the first of the two sheet tabs.
Hold down Ctrl while you click on the second of the two sheet tabs.
You have now selected both sheets.
Option 1: Drag one of the selected sheet tabs to the right (the other will come with it). Before you drop it, press and hold Ctrl.
Option 2: Right-click any of the selected sheet tabs.
Select 'Move or Copy' from the context menu.
Tick the check box 'Create a copy'.
Select '(move to end)' in the 'Before sheet' list box.
Click OK.
Both options will copy both sheets, and adjust the formulas linking them correctly.
Important: before you enter anything in the copied sheets, either click on another sheet tab, or right-click on one of the selected sheet tabs, then select 'Ungroup sheets' from the context menu.
If you forget to do that, anything you enter will be entered on both sheets at the same time.
- Sorry for the delay in replying only I have been away on holiday.
This worked perfectly - I used option 2. Thank you so much again!
