| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows too narrow/cuts top of text only when printing | Excel Discussion (Misc queries) | |||
| inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
| Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions | |||
| How do I make a sheet that combines all tabbed sheets & update as. | New Users to Excel | |||
![John G.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
