Using the Save As Webpage function in Excell

[Guest]

I'm wanting to use the Save as webpage in excell so that i can set the data
of a couple row's to show up usingmy active desktop so it is there for eisier
refrence, but the problem i'm having is this.

It shows the data but there is a bunch if white area round the information
that I entred. a huge white border or something. Is there anyway to get it to
just show the rows i want with out the white back ground?

 

[Bryan Hessey]

Dustin,

If this is for viewing for the current worksheet then perhaps easie
for you is in the Window 'Split' option, where you can size the uppe
pane to just a couple of rows, and scroll that to any row you wish t
view.


For your web save, you could locate your last used column and enter th
next column:IV in the name box to select all unused columns, the
rightmouse in the selected area and Delete. SaveAs a new workbook, the
try the Save As Webpage. (ie. if your last used column is X you woul
enter W:IV) note: The effect is not shown until after a Save of th
workbook.

Hope this helps