Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Problem
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy and Paste Problem
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. "Skc" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
copy and paste code problem | Excel Worksheet Functions |