copy and paste text to entire workbook

  • Thread starter Thread starter Rico
  • Start date Start date
R

Rico

Can anyone tell me how to copy cells on one sheet and
then paste to the entire workbook without going to each
sheet to paste?
 
Copy your range.
Group the sheets in the new workbook and paste to all the grouped sheets.

You can click on the first and ctrl-click on subsequent to group some.

You can rightclick on a worksheet tab and "select all sheets", too.

Make sure you ungroup when you're done. Any change to a grouped sheet will be
on each of the grouped sheets.

(Just rightclick on a grouped worksheet tab and select ungroup sheets)
 
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

update data from one workbook to another 4
copying one sheet to another workbook 3
Pasting copied AutoFiltered cells in Excel2007 9
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel Move or Copy Stopped Working? 0
problems getting this macro to work 23
Move/Copy sheet to another workbook error 2
Merge Multiple workbook sheets into one workbook 0

Back
Top