View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
bete bete is offline
external usenet poster
 
Posts: 6
Default 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