worksheet has 1 page of data but is 84 pages long

D

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?
 
K

Ken Johnson

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

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail merge labels 8 per page, but 84 is not divisible by 8 3
Need help modifying code 0
Excel --> Word 4
Page numbering with Merged Document and IF statements 1
Changing margins on 2nd page of letterhead template 4
Space at end of multi page list to accommodate new entries 1
VBA to do a mailmerge from a Specific Excel worksheet 0
Two columns followed by single page-width column on same page 0

Top