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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies