Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-582931%22%20slang%3D%22en-US%22%3EHow%20do%20I%20delete%20%22extra%22%20pages%20at%20the%20end%20of%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-582931%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20that%20has%20five%20pages%20of%20data.%26nbsp%3B%20Somehow%20I%20have%2018%20pages%20added%20to%20the%20end%20of%20this%20worksheet%20and%20I%20can't%20figure%20out%20how%20to%20delete%20these%20extra%20pages.%26nbsp%3B%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-582931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583222%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20delete%20%22extra%22%20pages%20at%20the%20end%20of%20a%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583222%22%20slang%3D%22en-US%22%3ESelect%20the%20first%20row%20*below*%20the%20last%20one%20that%20you%20wish%20to%20keep.%20Now%20press%20control%2Bshift%2BEnd.%3CBR%20%2F%3EWithin%20the%20selected%20area%2C%20right-click%20and%20choose%20Delete.%20Select%20Entire%20rows.%20Click%20OK%20and%20save%20the%20file.%20You%20have%20now%20removed%20the%20extra%20pages.%3C%2FLINGO-BODY%3E
anita_stancil
Occasional Visitor

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies