Deleting rows, cuts and pastes affected tabbed sheets

J

John G.

When I am modifying one sheet in a work book, such as deleting rows or
cutting and pasting, it is doing the same thing on other tabbed sheets in the
work book. What the heck? How do I stop this from happening. This created 6
extra hours of work for me between yesterday and today.

John
 
J

John G.

I figured it out albiet accidently, I had my worksheets grouped. However that
happened, I have no clue. I just selected all the sheets, right clicked on
tabs and selected ungroup sheets. Go figure.
 
B

Bob I

Click a sheet tab and touch the "S" key.
I figured it out albiet accidently, I had my worksheets grouped. However that
happened, I have no clue. I just selected all the sheets, right clicked on
tabs and selected ungroup sheets. Go figure.

:
Click to expand...
 
G

Gord Dibben

Without using VBA, the only way to group them is through user intervention.


Gord Dibben MS Excel MVP
 

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

Deleting rows in a workbook though all coresponding sheets 2
macro & selecting multiple sheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Macro that deletes and pastes filterd rows and then some 2
Excel Macro issue - How to copy and paste select rows from one sheet to another 2
Deleting rows and detecting range for format 8
hide rows variable row length 2
Newbie Web Query and Date Formatting + Error Handling 3

Top