![]() |
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? |
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