Save as html

[John Tippet]

I recently upgraded from Office 97 running on a Windows
98 machine to Office 2003 running on an XP machine. With
the Office 97 version of Excel, when I do a "save as
html" the file that is created has the cells formatted
with shadowed bars around them. When I do a "save as web
page" in the newer version of Excel, the shadowed bars
are missing. How can I get the same formatting as with
the older version of Excel?

 

[Earl Kiosterud]

John,

Excel has come a long way with html since Excel 97. It looks considerably
more in a browser like it does in Excel. Probably your only bet is to use
borders (Format - Cells - Borders) wherever you want lines. That'll put it
as a giant html table, and give you most of the Excel borders. It doesn't
show the diagonal lines, for one.

 

[Guest]

Earl:

OK. That added the borders as they "look" in Excel, but
they aren't shadowed borders as they were in Office 97,
but I am willing to live with that. The biggest problem
I have is that my 497 KB Excel file turned into a 3.7 MB
html file. Is there any way I can get a much smaller
file? When I tried Shift Edit "Copy as picture" as you
recommended in a response to a similar question posted on
this forum, I get the message that the file is too big
and will be truncated.

John Tippet

 

[Harald Staff]

Hi John

Select the desired cells only, and save only the selection, not the entire
workbook, as a webpage.

For really small html files, see
http://www.mvps.org/dmcritchie/excel/xl2html.htm
- but don't complaint if those look a little different than excel does. It's
the cosmetics that bloat files.

HTH. Best wishes Harald