how do i copy n paste one cell to another in different worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am tryiing to copy one cell to multiple worksheets without having to do
each one separately. Is there a way to do this?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Absolute References and worksheets 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to use multiple command button to copy user form data to multiple worksheet 0
Multiple Numbers in a cell 3
How do I combine data from multiple worksheets into one master lis 3
Using Worksheet Name 3

Back
Top