Deleting rows, cuts and pastes affected tabbed sheets
 

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

Deleting rows, cuts and pastes affected tabbed sheets
 

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.

"John G." wrote:

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

Deleting rows, cuts and pastes affected tabbed sheets
 

Click a sheet tab and touch the "S" key.

John G. wrote:

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.

"John G." wrote:


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

Deleting rows, cuts and pastes affected tabbed sheets
 

Gak!

R-click a sheet tab and touch the "S" key.

Bob I wrote:

Click a sheet tab and touch the "S" key.

John G. wrote:

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.
"John G." wrote:


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

Deleting rows, cuts and pastes affected tabbed sheets
 

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


Gord Dibben MS Excel MVP

On Fri, 27 Jun 2008 09:30:02 -0700, John G.
wrote:

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.

"John G." wrote:

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