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.

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.

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.

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

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

asked Nov 21 at 11:10

user965868

111

asked Nov 21 at 11:10

user965868

111

asked Nov 21 at 11:10

user965868

111

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.

edited Nov 21 at 15:37

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

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

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

Name

Required, but never shown

1 Answer
1

active

oldest

votes

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

edited Nov 21 at 15:37

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

edited Nov 21 at 15:37

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

edited Nov 21 at 15:37

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

edited Nov 21 at 15:37

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

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

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

@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

@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');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Vrftjkry