View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Delete rows at end of sheet

But the key words in what Gord posted are "...at the end of A sheet." And
THE Key Word in that phrase being "A": singular.
Yes, deleting and inserting rows does affect grouped sheets, just as typing
an entry or formula into a cell causes it to appear on all grouped sheets.

Wise to have notes to remind yourself of such behavior.

"Evan Weiner" wrote:

A year ago Gord Dibben posted a way to delete blank rows at the end of a
sheet. If sheets are grouped (all selected), they seem to get the same
truncation. This can be a rude awakening, especially if the book is not
backed up. My notes now say:

Ungroup sheets
Select row after last useful one
Ctl-Shift-End
Edit Delete... Entire row
Save document