ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using the Save As Webpage function in Excell (https://www.excelbanter.com/excel-discussion-misc-queries/50697-using-save-webpage-function-excell.html)

Dustin

Using the Save As Webpage function in Excell
 
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

Using the Save As Webpage function in Excell
 

Dustin,

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


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

Hope this helps




Dustin Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476673



All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com