Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 694
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
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

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 694
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Size Between Worksheets when performing a copy and paste Kara Excel Discussion (Misc queries) 1 October 27th 06 04:08 AM
how do i copy n paste one cell to another in different worksheets ucastores Excel Worksheet Functions 1 October 3rd 06 01:49 PM
Copy content of cell to another depending on value of third cell(between worksheets) Zeljko Milak Excel Worksheet Functions 2 July 14th 06 07:17 PM
Copy worksheet & maintain cell reference across worksheets dingy101 Excel Worksheet Functions 3 January 2nd 06 11:51 AM
how do you copy the same cell reference on different worksheets abee Excel Worksheet Functions 1 June 15th 05 01:48 AM


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"