Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i copy a cell in worksheets 10 to the other 9 worksheets
i want to copy a cell from worksheet 10 to the other worksheets but when i
use copy and i then highlight tabs with shift or control then paste link is greyed out. how can i copy from one cell in a worksheet to other worksheets so that when i update the cell all worksheets change thank you |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i copy a cell in worksheets 10 to the other 9 worksheets
Hi Bete:
Once you have copied the cell just seelct the other sheet, don't use the shift or control keys and then paste it on the other sheet. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "bete" wrote: i want to copy a cell from worksheet 10 to the other worksheets but when i use copy and i then highlight tabs with shift or control then paste link is greyed out. how can i copy from one cell in a worksheet to other worksheets so that when i update the cell all worksheets change thank you |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i copy a cell in worksheets 10 to the other 9 worksheet
thank you for your answer however i thought their was a procedure where i
could copy of the cell and then click on the other 9 tabs and it would link up to the tenth worksheet this is why i was trying to find out if shift or control would work. "Martin Fishlock" wrote: Hi Bete: Once you have copied the cell just seelct the other sheet, don't use the shift or control keys and then paste it on the other sheet. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "bete" wrote: i want to copy a cell from worksheet 10 to the other worksheets but when i use copy and i then highlight tabs with shift or control then paste link is greyed out. how can i copy from one cell in a worksheet to other worksheets so that when i update the cell all worksheets change thank you |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i copy a cell in worksheets 10 to the other 9 worksheet
Hi Bete:
Ok if you want to copy a cell and paste it into the 9 backing sheets copy te cell on sheet10 then select the other sheets using the control key and the mouse to select individual sheets or select the first sheet and them the shift select last sheet and then move the cursor to the cell and paste it. OK should work. Remember to un group the sheets afterwards. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "bete" wrote: thank you for your answer however i thought their was a procedure where i could copy of the cell and then click on the other 9 tabs and it would link up to the tenth worksheet this is why i was trying to find out if shift or control would work. "Martin Fishlock" wrote: Hi Bete: Once you have copied the cell just seelct the other sheet, don't use the shift or control keys and then paste it on the other sheet. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "bete" wrote: i want to copy a cell from worksheet 10 to the other worksheets but when i use copy and i then highlight tabs with shift or control then paste link is greyed out. how can i copy from one cell in a worksheet to other worksheets so that when i update the cell all worksheets change thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Size Between Worksheets when performing a copy and paste | Excel Discussion (Misc queries) | |||
how do i copy n paste one cell to another in different worksheets | Excel Worksheet Functions | |||
Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
how do you copy the same cell reference on different worksheets | Excel Worksheet Functions |