Eliminating extra pages

[BillVasko]

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!!

 

[Macropheliac]

Is the "extra crap" you mention worksheets?

 

[BillVasko]

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]

I see. Can you just delete everything after the 2 pages? If not setting the PrintArea may help.

 

[BillVasko]

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

 

[BillVasko]

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]

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]

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]

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???