Excel Workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-3457336%22%20slang%3D%22en-US%22%3EExcel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457336%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20basic%20question%20but%20I%20need%20help.%20I%20have%20created%20a%20workbook%20where%20the%20data%20is%2015%20pages%20long%2C%20but%20the%20workbook%20continues%20to%2018669%20pages%20long!%3C%2FP%3E%3CP%3EHow%20do%20I%20insert%20a%20page%20end%2C%20or%20how%20can%20I%20quickly%20get%20rid%20of%20all%20the%20excess%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3457336%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457414%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457414%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1410656%22%20target%3D%22_blank%22%3E%40jennygates%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20deleting%20all%20unused%20rows%20below%20the%20last%20used%20row%2C%20and%20all%20unused%20columns%20to%20the%20last%20used%20column.%3C%2FP%3E%0A%3CP%3EThen%20save%20the%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457435%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457435%22%20slang%3D%22en-US%22%3EThanks%20-%20I've%20been%20doing%20that%20and%20will%20continue.%20I%20was%20just%20hoping%20for%20a%20quicker%20solution%20to%20deleting%20all%20those%20extra%20rows.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457492%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457492%22%20slang%3D%22en-US%22%3EI%20may%20be%20wrong%20here%20but%20in%20your%20workbook%20have%20you%20a%20hi%20lighted%20header%20that%20goes%20past%20your%20headed%20cells%20or%20cells%20do%20you%20have%20cells%20bordered%20out%20side%20your%20table%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457533%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457533%22%20slang%3D%22en-US%22%3EI%20do%20not%20(that%20I'm%20aware%20of).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457567%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457567%22%20slang%3D%22en-US%22%3EOk...%20is%20it%20pages%20for%20printing%20you%20need%20removed%20or%20sheets%20you%20looking%20to%20remove.%20Sorry%20for%20sounding%20dumb%20but%20just%20trying%20to%20get%20were%20we%20are%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3457966%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F635882%22%20target%3D%22_blank%22%3E%40Norman_Glenn%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20suggestions.%20I%20resolved%20the%20issue%20by%20just%20starting%20from%20the%20bottom%20up%2C%20and%20deleting%20rows%20until%20I%20got%20to%20the%20bottom%20of%20my%20last%20data%20page.%20Hallelujah!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3462271%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3462271%22%20slang%3D%22en-US%22%3EWell%20all%20learn%20something%20glad%20you%20shard%3C%2FLINGO-BODY%3E
New Contributor

This is a basic question but I need help. I have created a workbook where the data is 15 pages long, but the workbook continues to 18669 pages long!

How do I insert a page end, or how can I quickly get rid of all the excess?

7 Replies

@jennygates 

Try deleting all unused rows below the last used row, and all unused columns to the last used column.

Then save the workbook.

Thanks - I've been doing that and will continue. I was just hoping for a quicker solution to deleting all those extra rows.
I may be wrong here but in your workbook have you a hi lighted header that goes past your headed cells or cells do you have cells bordered out side your table
I do not (that I'm aware of).
Ok... is it pages for printing you need removed or sheets you looking to remove. Sorry for sounding dumb but just trying to get were we are

@Norman_Glenn thank you for your suggestions. I resolved the issue by just starting from the bottom up, and deleting rows until I got to the bottom of my last data page. Hallelujah!

Well all learn something glad you shard