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. |
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. |
All times are GMT +1. The time now is 04:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com