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

How do I find only the singular rows in a sheet with duplicates? 2
Macro that deletes and pastes filterd rows and then some 2
macro & selecting multiple sheets 1
Cutting and pasting between tables 0
hide rows variable row length 2
Macro for removing specific rows and columns, freezing panes..? 3
Mail appears deleted from inbox. 0
auto-hide rows, cell format (# and @), update cell refs, shade cel 0

Top