I know that this can be done because I've done it before. I just cannot
remember how.

I have 20 sheets tabs
I want to copy a range of cells from sheet1 and paste them over to sheet2
thru sheet 20. What I'm doing now is going into each tab and highlighting the
range of cells I want to paste the data into and then I paste it across the
sheets. How can I group all sheets tabs at once and highlight the range of
cells in one shot so I don't have to go into each one?

It probably doesn't matter, but I'm using Excel 2003

Thanks, Karen

Hi Karen,
You have to select all the tabs at once, holding the shift key select the
first one and then click on the last tab it will highlight all of them. Now
go to the cell or column where you want to paste the information and paste
it. It will paste in all others tabs as well

"Karen" wrote:

I know that this can be done because I've done it before. I just cannot
remember how.

I have 20 sheets tabs
I want to copy a range of cells from sheet1 and paste them over to sheet2
thru sheet 20. What I'm doing now is going into each tab and highlighting the
range of cells I want to paste the data into and then I paste it across the
sheets. How can I group all sheets tabs at once and highlight the range of
cells in one shot so I don't have to go into each one?

It probably doesn't matter, but I'm using Excel 2003

Thanks, Karen

Copy a range of cell from Sheet1, hold down Shift Key and select Sheet2 to
Sheet20 and Paste


"Karen" wrote:

I know that this can be done because I've done it before. I just cannot
remember how.

I have 20 sheets tabs
I want to copy a range of cells from sheet1 and paste them over to sheet2
thru sheet 20. What I'm doing now is going into each tab and highlighting the
range of cells I want to paste the data into and then I paste it across the
sheets. How can I group all sheets tabs at once and highlight the range of
cells in one shot so I don't have to go into each one?

It probably doesn't matter, but I'm using Excel 2003

Thanks, Karen

Thank you for your help! It worked great!
Karen

"Eduardo" wrote:

Hi Karen,
You have to select all the tabs at once, holding the shift key select the
first one and then click on the last tab it will highlight all of them. Now
go to the cell or column where you want to paste the information and paste
it. It will paste in all others tabs as well

"Karen" wrote:

I know that this can be done because I've done it before. I just cannot
remember how.

I have 20 sheets tabs
I want to copy a range of cells from sheet1 and paste them over to sheet2
thru sheet 20. What I'm doing now is going into each tab and highlighting the
range of cells I want to paste the data into and then I paste it across the
sheets. How can I group all sheets tabs at once and highlight the range of
cells in one shot so I don't have to go into each one?

It probably doesn't matter, but I'm using Excel 2003

Thanks, Karen

Thank you for your help! It worked great!
Karen


"Teethless mama" wrote:

Copy a range of cell from Sheet1, hold down Shift Key and select Sheet2 to
Sheet20 and Paste


"Karen" wrote:

I know that this can be done because I've done it before. I just cannot
remember how.

I have 20 sheets tabs
I want to copy a range of cells from sheet1 and paste them over to sheet2
thru sheet 20. What I'm doing now is going into each tab and highlighting the
range of cells I want to paste the data into and then I paste it across the
sheets. How can I group all sheets tabs at once and highlight the range of
cells in one shot so I don't have to go into each one?

It probably doesn't matter, but I'm using Excel 2003

Thanks, Karen