ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i copy n paste one cell to another in different worksheets (https://www.excelbanter.com/excel-worksheet-functions/112643-how-do-i-copy-n-paste-one-cell-another-different-worksheets.html)

ucastores

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?

Dave F

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?



All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com