How do I delete "extra" pages at the end of a worksheet

Copper Contributor

I have a worksheet that has five pages of data.  Somehow I have 18 pages added to the end of this worksheet and I can't figure out how to delete these extra pages.  Any suggestions?

1 Reply
Select the first row *below* the last one that you wish to keep. Now press control+shift+End.
Within the selected area, right-click and choose Delete. Select Entire rows. Click OK and save the file. You have now removed the extra pages.