Forum Discussion

jennygates's avatar
jennygates
Copper Contributor
Jun 01, 2022

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_Glenn's avatar
    Norman_Glenn
    Brass Contributor
    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
      • Norman_Glenn's avatar
        Norman_Glenn
        Brass Contributor
        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
  • jennygates 

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

    Then save the workbook.

    • jennygates's avatar
      jennygates
      Copper Contributor
      Thanks - I've been doing that and will continue. I was just hoping for a quicker solution to deleting all those extra rows.

Resources