View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default worksheet has 1 page of data but is 84 pages long

Most likely there is a cell somewhere that inadvertently got filled
with data somehow. The fixes for this a
1. Define the print range to include just the real data; or
2. Highlight, then delete or clear all the columns to the right of your
desired data, and highlight and delete or clear all the rows below your
desired data. (I would go with this one, myself.) This removes the
phantom entry.