Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing Multiple Sheets
I often perform a search in Excel over multiple sheets in the same workbook.
I also often move rows within one sheet. When multiple sheets are selected and you cut / copy / paste on the sheet you have selected, it will perform the same action on all of the sheets selected. I'm not sure if this was planned or there is a purpose for this capability, but it seems counterintuitive to me. It took me weeks to figure out why there were changes being made in other sheets that should not have occurred. This has compromised my data and a simple warning message or something similar stating "your edits to this sheet will affect all of the selected sheets, do you want to continue - Yes / No" would have been a life-saver. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple formula editing | Excel Discussion (Misc queries) | |||
Editing multiple cells with one action???? | Excel Discussion (Misc queries) | |||
multiple cell editing | Excel Worksheet Functions | |||
editing multiple sheets at once | Excel Discussion (Misc queries) | |||
Editing from Multiple computers? | Excel Discussion (Misc queries) |