Copy and Paste Problem

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

Guest

Regarding the error I am having on excel. The spreadsheet contains many
worksheets. If I ctrl and f with all the worksheets highlighted I seem not
to be able to copy and paste into another sheet. If I go directly into the
worksheet and search then it copy and pastes fine.
 
ctrl-f is find/replace. Are you trying to find something, or copy it?

I think I know what you are asking though. Here's my guess.

Say you want all values "ABCD" in worksheets 1-10 to be "EFGH"
What I would do, is:
Select worksheets 1-10
ctrl-a (select all) on the visible worksheet
ctrl-h (find/replace) "ABCD" to "EFGH"
select the visible worksheet only.

All values on those sheets should now be correct.
You can also do this by row, column, or selected cels once you've selected
the desired worksheets. You can't do DIFFERENT cells on each worksheet
though, unless you select all.
Hope that helps.
 

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

Cannot copy worksheet to another file 2
Copy-Paste Chart into Word from Excel 2007 3
Multiple worksheet Copy Paste Macro 2
I can't copy and paste equations 0
Copy and Past Values AND Formatting AND Text 1
Paste unavailable 2
Copy checkboxes created with Excel97 1
copy formulas from one worksheet to an entirely different workshee 2

Back
Top