Editing Multiple Sheets

[lmtappa]

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/com...3-328d7250a560&dg=microsoft.public.excel.misc

 

[Gord Dibben]

You don't have to select multiple sheets to search across sheets.

The search options allow search in "workbook".

The grouping of sheets is a handy feature and is used in the manner you
describe..........doing the same things to multiple sheets.

When sheets are grouped, the sheet tabs will turn white and you will see [Group]
on the title bar after the filename.

I agree that when selecting multiple sheets a message should pop up similar to
when you right-click and "Delete Sheet"


Gord Dibben MS Excel MVP