Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy n paste one cell to another in different worksheets
I am tryiing to copy one cell to multiple worksheets without having to do
each one separately. Is there a way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i copy n paste one cell to another in different worksheets
Yes.
Do the following: 1) Select the cell you want to copy, and copy it. 2) Hold the CTRL button and select all the tabs into which you want to paste the copied cell. 3) Once all the relevant tabs have been selected, highlight the appropriate place in the active sheet to paste the cell. The cell will be pasted in the same place in all the worksheets you have grouped together. 4) To ungroup all these tabs, right-click on one of them and select 'ungroup'. Dave -- Brevity is the soul of wit. "ucastores" wrote: I am tryiing to copy one cell to multiple worksheets without having to do each one separately. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy data in Excel cells and paste in Word w/o cell borde | Excel Discussion (Misc queries) | |||
disabling the copy paste function in a cell | Excel Worksheet Functions | |||
copy a list of items from word and paste in cell | Excel Discussion (Misc queries) | |||
How to embed an image withon a cell as opossed to copy and paste | Charts and Charting in Excel | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions |