worksheet has 1 page of data but is 84 pages long

[Donna 12589]

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?

[Ken Johnson]

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

[Dave O]

Most likely there is a cell somewhere that inadvertently got filled
with data somehow. The fixes for this are:
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.

[Gord Dibben]

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" <[email protected]> wrote:

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

[Ken Johnson]

Hi Gord,
Thanks for that.
Ken Johnson