Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
Macro - copy a range and paste it in a new sheet 12 times | Excel Worksheet Functions | |||
copy and paste cells non-randomly form range | Excel Discussion (Misc queries) | |||
copy/paste won't refer to the appropriate range of cells | Excel Discussion (Misc queries) | |||
How do I copy the contents of a range of text cells and paste into one cell? | Excel Discussion (Misc queries) |