Excel Spreadsheet

[Brenda]

I have an Excel spreadsheet that I am using to track data
on capacitors. The first time I viewed the spreadsheet in
print preview it had added extra pages from the bottom of
the last complete page. That was easy to delete.

Now my document is 46 pages long. The spreadsheet has
added empty pages vertically. For example, in print
preview, across from page 1 is page 47 which is empty.
The empty pages continue through page 92. I have tried
everything I can think to do to delete them without
destroying the entire document.

Why does Excel keep adding empty pages, and how can I
delete pages 47 through 92?

 

[dvt]

I have an Excel spreadsheet that I am using to track data
on capacitors. The first time I viewed the spreadsheet in
print preview it had added extra pages from the bottom of
the last complete page. That was easy to delete.

Now my document is 46 pages long. The spreadsheet has
added empty pages vertically. For example, in print
preview, across from page 1 is page 47 which is empty.
The empty pages continue through page 92. I have tried
everything I can think to do to delete them without
destroying the entire document.

Why does Excel keep adding empty pages, and how can I
delete pages 47 through 92?

Sounds like you have a few columns to the right of your data that need to
be deleted. When you press the keys control-end, does the cursor go
beyond the end or your data? For example, if your data is in A1:F1000,
does the cursor go to H1000?

In the example above, you would need to delete columns G and H. Click on
the G at the top of the spreadsheet to select the entire column drag over
to the H, then Edit | Delete. You'll have to save the file then press
control-end again. Hopefully the cursor goes to F1000 now. In some
versions of Excel you have to close and re-open the file for the
correction to stick.

If all else fails, go to File | Page setup and set the print range to
A1:F1000.