Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 05:51 PM
Sara
 
Posts: n/a
Default How do I delete pages?

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?

  #2   Report Post  
Old December 1st 04, 05:59 PM
h317
 
Posts: n/a
Default

Once the page range is setup and saved, it's there for the next user to print
by just clicking the print button.

Alternatively, you can do [End]+[Home] and delete the row and column that
the last activecell is on. Save the file and the active range will be back to
6 pages long.

"Sara" wrote:

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?

  #3   Report Post  
Old December 2nd 04, 12:06 AM
Gord Dibben
 
Posts: n/a
Default

Sara

For complete instructions on re-setting the actual used range see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 08:51:03 -0800, "Sara"
wrote:

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?


  #4   Report Post  
Old December 7th 04, 11:49 PM
Sara
 
Posts: n/a
Default

Gord-
I went to the site, but she said that if there are merged cells (which there
are), then her code wouldn't work (which it didn't). Is there ANYTHING else I
can do to get rid of these extra pages?!
Thanks for your time,
Sara

"Gord Dibben" wrote:

Sara

For complete instructions on re-setting the actual used range see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 08:51:03 -0800, "Sara"
wrote:

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?



  #5   Report Post  
Old December 7th 04, 11:53 PM
Debra Dalgleish
 
Posts: n/a
Default

You should be able to manually delete the unused rows and columns.
Then, save and close the file.



Sara wrote:
Gord-
I went to the site, but she said that if there are merged cells (which there
are), then her code wouldn't work (which it didn't). Is there ANYTHING else I
can do to get rid of these extra pages?!
Thanks for your time,
Sara

"Gord Dibben" wrote:


Sara

For complete instructions on re-setting the actual used range see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 08:51:03 -0800, "Sara"
wrote:


I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



  #6   Report Post  
Old December 8th 04, 02:25 AM
Gord Dibben
 
Posts: n/a
Default

Sara

Find the bottom row of your actual data range.

Select row below and SHIFT + END + DownArrow.

EditDeleteEntire Rows.

Same for columns to the right of data.

NOW! IMPORTANT!! Save the workbook, close and re-open to see difference in
used range.

Debra has this same method on her pages.

Gord

On Tue, 7 Dec 2004 14:49:02 -0800, "Sara"
wrote:

Gord-
I went to the site, but she said that if there are merged cells (which there
are), then her code wouldn't work (which it didn't). Is there ANYTHING else I
can do to get rid of these extra pages?!
Thanks for your time,
Sara

"Gord Dibben" wrote:

Sara

For complete instructions on re-setting the actual used range see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 08:51:03 -0800, "Sara"
wrote:

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?






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
Delete Chart agac8103 Charts and Charting in Excel 3 December 13th 04 05:54 AM
delete rows dd Links and Linking in Excel 1 December 2nd 04 12:33 AM
Delete links Mohamed Excel Discussion (Misc queries) 2 November 29th 04 11:10 PM
print titles won't appear on some pages amzy19 Excel Discussion (Misc queries) 1 November 28th 04 12:16 PM
Limiting the # of pages for Repeat Column Labels LarryF Excel Discussion (Misc queries) 1 November 27th 04 01:21 AM


All times are GMT +1. The time now is 05:10 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017