Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 17
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default 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
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
How do I copy data in Excel cells and paste in Word w/o cell borde Nsimm13 Excel Discussion (Misc queries) 1 September 1st 06 03:35 PM
disabling the copy paste function in a cell sam Excel Worksheet Functions 0 February 22nd 06 02:10 PM
copy a list of items from word and paste in cell Priscilla Excel Discussion (Misc queries) 1 November 11th 05 06:51 PM
How to embed an image withon a cell as opossed to copy and paste Karla Rodriguez Charts and Charting in Excel 3 November 4th 05 03:01 PM
hpw do I logic test a cell then copy the row to diff. SS Debi Excel Worksheet Functions 4 October 5th 05 09:42 PM


All times are GMT +1. The time now is 01:11 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"