Copy same data on each worksheet (there are about 80) on Excel
up vote
2
down vote
favorite
I want to be able to copy and paste the cells from sheet 1 onto all the sheets in my workbook.
Is there a quick way to do this, so in one go, rather than go to each individual sheet and click paste?
The data in each sheet will be pasted in the same cells.
microsoft-excel
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
asked Nov 21 at 11:10
user965868
111
add a comment |
up vote
2
down vote
favorite
I want to be able to copy and paste the cells from sheet 1 onto all the sheets in my workbook.
Is there a quick way to do this, so in one go, rather than go to each individual sheet and click paste?
The data in each sheet will be pasted in the same cells.
microsoft-excel
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
asked Nov 21 at 11:10
user965868
111
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I want to be able to copy and paste the cells from sheet 1 onto all the sheets in my workbook.
Is there a quick way to do this, so in one go, rather than go to each individual sheet and click paste?
The data in each sheet will be pasted in the same cells.
microsoft-excel
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
asked Nov 21 at 11:10
user965868
111
I want to be able to copy and paste the cells from sheet 1 onto all the sheets in my workbook.
Is there a quick way to do this, so in one go, rather than go to each individual sheet and click paste?
The data in each sheet will be pasted in the same cells.
microsoft-excel
microsoft-excel
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
asked Nov 21 at 11:10
user965868
111
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
asked Nov 21 at 11:10
user965868
111
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
edited Nov 21 at 12:48
Aulis Ronkainen
6131514
6131514
asked Nov 21 at 11:10
user965868
111
asked Nov 21 at 11:10
user965868
111
asked Nov 21 at 11:10
user965868
111
111
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
3
down vote
This is how to do it:
- Select the data in Sheet 1
- Copy using Ctrl+C
- Click the tab for Sheet 2 and then click inside this tab where
the paste of the selected cells will start - Holding Shift, click the tab for the last sheet
- Paste using Ctrl+V
After choosing multiple sheets, [Group] appears in the title bar at the
top of the worksheet. To cancel the group, click any unselected worksheet, or
right-click the tab of any selected sheet and click Ungroup Sheets.
answered Nov 21 at 11:19
harrymc
249k10257550
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
|
show 2 more comments
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
3
down vote
This is how to do it:
- Select the data in Sheet 1
- Copy using Ctrl+C
- Click the tab for Sheet 2 and then click inside this tab where
the paste of the selected cells will start - Holding Shift, click the tab for the last sheet
- Paste using Ctrl+V
After choosing multiple sheets, [Group] appears in the title bar at the
top of the worksheet. To cancel the group, click any unselected worksheet, or
right-click the tab of any selected sheet and click Ungroup Sheets.
answered Nov 21 at 11:19
harrymc
249k10257550
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
|
show 2 more comments
up vote
3
down vote
This is how to do it:
- Select the data in Sheet 1
- Copy using Ctrl+C
- Click the tab for Sheet 2 and then click inside this tab where
the paste of the selected cells will start - Holding Shift, click the tab for the last sheet
- Paste using Ctrl+V
After choosing multiple sheets, [Group] appears in the title bar at the
top of the worksheet. To cancel the group, click any unselected worksheet, or
right-click the tab of any selected sheet and click Ungroup Sheets.
answered Nov 21 at 11:19
harrymc
249k10257550
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
|
show 2 more comments
up vote
3
down vote
up vote
3
down vote
This is how to do it:
- Select the data in Sheet 1
- Copy using Ctrl+C
- Click the tab for Sheet 2 and then click inside this tab where
the paste of the selected cells will start - Holding Shift, click the tab for the last sheet
- Paste using Ctrl+V
After choosing multiple sheets, [Group] appears in the title bar at the
top of the worksheet. To cancel the group, click any unselected worksheet, or
right-click the tab of any selected sheet and click Ungroup Sheets.
answered Nov 21 at 11:19
harrymc
249k10257550
This is how to do it:
- Select the data in Sheet 1
- Copy using Ctrl+C
- Click the tab for Sheet 2 and then click inside this tab where
the paste of the selected cells will start - Holding Shift, click the tab for the last sheet
- Paste using Ctrl+V
After choosing multiple sheets, [Group] appears in the title bar at the
top of the worksheet. To cancel the group, click any unselected worksheet, or
right-click the tab of any selected sheet and click Ungroup Sheets.
answered Nov 21 at 11:19
harrymc
249k10257550
edited Nov 21 at 15:37
answered Nov 21 at 11:19
harrymc
249k10257550
answered Nov 21 at 11:19
harrymc
249k10257550
answered Nov 21 at 11:19
harrymc
249k10257550
249k10257550
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
|
show 2 more comments
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
Thanks for the answer, I didn't realise this was possible. However, it appears that the data is not pasted to the same location in the target sheets as it was copied from in the source sheet. Instead, it is copied to the currently selected location in each sheet (A1 by default).
– Blackwood
Nov 21 at 13:23
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
great answer, as for comment @Blackwood before you select ALL the sheets, click into the cell where you want the data pasted, then select all sheets and paste, so if you copy C2:H2, select cell C2 on the sheet where you will be pasting, then select all sheets etc. hope that makes sense
– PeterH
Nov 21 at 13:39
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
@PeterH Yes. As I said, the data is copied to the currently selected location in each sheet. Selecting the desired location in each of 80 worksheets is about as time consuming as pasting separately to each sheet.
– Blackwood
Nov 21 at 13:42
1
1
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
@Blackwood you only need to select the location on first of the sheets you paste to, and it will use that location on ALL of the sheets, try it for yourself it works for me.
– PeterH
Nov 21 at 14:48
1
1
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
@PeterH: Thanks for making it clear. I have added this missing piece to my answer.
– harrymc
Nov 21 at 15:39
|
show 2 more comments
draft saved
draft discarded
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1377247%2fcopy-same-data-on-each-worksheet-there-are-about-80-on-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
