Delete line in sheet, deletes same line in add'l sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I delete a line in one sheet, the process continues to delete the same
lines in additional sheets (also losing the information). i.e., I have
sheets ab, cd, ef through end of alphabet. I need to delete line 37 on sheet
cd, and the process deletes the same lines on all sheets. How do I correct
this? Thank you.
 
Sue

Un-group the sheets. (You will likely have [Group] on the top title bar).
While sheets are grouped, anything you do to one is reflected on another.
These are grouped by holding the Ctrl key and clicking sheet tabs
(non-contiguous) or click a sheet tab and holding down the shift key, click
on another (contiguous).

Now...... to un-group

Click on a non-grouped tab, or right click on a grouped tab and select
ungroup


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top