worksheet has 1 page of data but is 84 pages long
 

I have several worksheets in a workbook but 1 worksheet is 84 pages long with
only data to fill 1 page. What can I do to reduce it to the single page it
really is?

worksheet has 1 page of data but is 84 pages long
 

Hi Donna,
What happens if you select all empty cells, Clear All, save, close then
reopen?
Ken Johnson

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.

worksheet has 1 page of data but is 84 pages long
 

Ken

Clearing the cells and saving will not reset the used range.

You must delete the unused rows and columns then save.


Gord Dibben MS Excel MVP

On 17 Jan 2006 06:57:40 -0800, "Ken Johnson" wrote:

Hi Donna,
What happens if you select all empty cells, Clear All, save, close then
reopen?
Ken Johnson

worksheet has 1 page of data but is 84 pages long
 

Hi Gord,
Thanks for that.
Ken Johnson