Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to delete extra pages in Excel?

I HAD a three page worksheet in Excel 2007, with percentages calculated and
some lines shaded.
This suddenly became a 67 page worksheet!!! I THINK some of the shading
lines got extended nearly to to infinity.
Is there a way to delete the additional 64 (or so) unwanted pages?
Thanks for any help with this.
Larry
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default How to delete extra pages in Excel?

Hi,

When you say pages, are you talking about Sheets or are you talking about
pages at printout?

1. Print only one page a printout, select the range you want to print and
choose Page Layout, Print Area, Set Print Area, or with the range selected
choose Office Button, Print, and turn on the Selection option.

2. You formatting probably extends to "infinity" because you probably
clicked the row number and then applied formatting, instead select the range
and apply the formatting. Set the rows' formats back to None and then
reformat the range.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Longwell" wrote:

I HAD a three page worksheet in Excel 2007, with percentages calculated and
some lines shaded.
This suddenly became a 67 page worksheet!!! I THINK some of the shading
lines got extended nearly to to infinity.
Is there a way to delete the additional 64 (or so) unwanted pages?
Thanks for any help with this.
Larry

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 225
Default How to delete extra pages in Excel?

Select the first blank row
Press END key
Press SHIFT-DOWN ARROW keys
Right-click and choose Delete
Save the workbook

Repeat for Columns, if required

"Longwell" wrote:

I HAD a three page worksheet in Excel 2007, with percentages calculated and
some lines shaded.
This suddenly became a 67 page worksheet!!! I THINK some of the shading
lines got extended nearly to to infinity.
Is there a way to delete the additional 64 (or so) unwanted pages?
Thanks for any help with this.
Larry

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I delete extra (blank) pages in excel??? Arbee5 Excel Discussion (Misc queries) 5 April 9th 23 12:49 PM
How to delete extra pages at end of excel file when printing Michelle Excel Discussion (Misc queries) 2 January 29th 08 07:27 PM
Delete extra pages older pro Excel Worksheet Functions 0 February 13th 07 12:04 AM
How do I delete unwanted extra pages on Excel worksheets RogerD Excel Discussion (Misc queries) 4 May 20th 06 11:53 PM
How do I delete extra blank pages from an excel worksheet? Satiricalbliss Excel Worksheet Functions 3 April 18th 06 09:23 PM


All times are GMT +1. The time now is 11:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"