ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can't delete blank pages (https://www.excelbanter.com/excel-discussion-misc-queries/24070-cant-delete-blank-pages.html)

Dee

Can't delete blank pages
 
I have a spreadsheet that when I go into print preview there are 59 pages. I
did not create the spreadsheet. However, there is only something on 3 of
those pages. How to I delete all of these extra pages.

Thanks very much for any help. I am using Excel 2003

Dee

bj

on the main sheet select just those areas you want to print and goto
<file<print area< set print area

"Dee" wrote:

I have a spreadsheet that when I go into print preview there are 59 pages. I
did not create the spreadsheet. However, there is only something on 3 of
those pages. How to I delete all of these extra pages.

Thanks very much for any help. I am using Excel 2003

Dee


Duke Carey

#1 - Select the range of cells you want to print, use the menu to choose
FilePrint AreaSet Print Area

#2 - You may have extraneous info in cells (blanks, formulas that evaluate
to "", etc) in cells outside your print area. see Debra Dalgleish's site

http://www.contextures.com/xlfaqApp.html#Unused

"Dee" wrote:

I have a spreadsheet that when I go into print preview there are 59 pages. I
did not create the spreadsheet. However, there is only something on 3 of
those pages. How to I delete all of these extra pages.

Thanks very much for any help. I am using Excel 2003

Dee



All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com