Forum Discussion
jennygates
Jun 01, 2022Copper Contributor
Excel Workbook
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?
- Norman_GlennBrass ContributorI 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
- jennygatesCopper ContributorI do not (that I'm aware of).
- Norman_GlennBrass ContributorOk... 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
Try deleting all unused rows below the last used row, and all unused columns to the last used column.
Then save the workbook.
- jennygatesCopper ContributorThanks - I've been doing that and will continue. I was just hoping for a quicker solution to deleting all those extra rows.