Eliminating extra pages

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
I have a 2 page excel document. However, for some reason, I have a bunch of extra crap that continues on past the pages. So when I post the document as a hyperlink on my web page, it not only shows the 2 page document, but it also shows all of the other extra pages. How do I eliminate all of these extra pages and confine my document just to 2 pages? Thanks!!
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
Not, it's not. I created some workout charts and the gridlines continue on for pages past my original 2 pages that I created. Also, the headers and footers show up on all of those "extra" pages. Thanks for your response.
 

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165
I see. Can you just delete everything after the 2 pages? If not setting the PrintArea may help.
 

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19

ADVERTISEMENT

I tried deleting everything, and I wasn't successful. I'll look at the print area. Thanks.
 

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
Selecting print area worked, thanks!!

Now, problem #2 in my other thread that you posted in........when I post a document onto my web page, if I created multiple worksheets within the document, none of them will show up on the web. So that is why i need to copy and paste worksheets into a new workbook, and find a way to keep all of the formatting in the columns and rows.
 

Macropheliac

Board Regular
Joined
Aug 26, 2005
Messages
165

ADVERTISEMENT

Maybe you could select every row beneathe the desired data, delete contents and clear all shading and borders. Sometimes, there's something there that you can't see. It's happened to me several times.
 

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
yeah, that's true, i know what you mean. selecting print area worked, so that's what i'm going to go with. but you bring up an interesting point that's always bothered me.

you said to make sure all content, shading, and borders are deleted. but let's say you created a chart using borders, but have not put in any data. you just want a blank chart to fill things in by hand. but when you print, excel doesn't print anything since there was no data. or they may print JUST the cells that have data. how do you solve this? will selecting print area solve this also, or is there another method?
 

BillVasko

New Member
Joined
Oct 3, 2006
Messages
19
well, i take it back. selectiong the print area does work if you are going to print the document, but it does not work for posting the document to the web!! anyone else have ideas???
 

Watch MrExcel Video

Forum statistics

Threads
1,112,799
Messages
5,542,574
Members
410,560
Latest member
1ndependent
Top