Delete rows at end of sheet

[Guest]

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

 

[Guest]

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.

 

[Gord Dibben]

Thanks Jerry.

Mayhaps I should start posting a caveat about making sure sheets are not grouped
when performing this operation<g>

A heads up to Debra also for her website.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord