Problems saving as html or pdf...

[Louie Warren]

I have a workbook that has data I want presented on the
Internet to allow people that don't have Excel or the same
version to view a sheet.

Saved as html:
1. Colors and fonts aren't as saved as they appear in the
spreadsheet. Everything is a standard size, Times New
Roman, and black.

2. The table cells aren't displayed as they are in the
spreadsheet. Some header cells are skewed to the right.
Column width isn't as in the spreadsheet.

With these two problems, I end up editing in FrontPage and
making it look as it did in the spreadsheet. However,
when I view the file with Internet Explorer, Some cells
are correct, but most of the body is all clustered
together, centered on the page. Any ideas as to what is
causing this and how I can fix it?

Saving as .pdf
Using PDF Writer, I print the sheet. I bring up Adobe PDF
Reader 6.01, to view the file. The first page is blank,
but all pages after that appear. I do the same procedure
with PowerPoint and it works fine. Any ideas as to what
is causing this and how I can fix it?

 

[David McRitchie]

Hi Louie,
Look at -- File, Page Setup, Sheets, uncheck Print B&W

What version of Excel -- HTML stuff changes with each version
How are you printing to your PDF printer.

Don't really expect your HTML to look exactly like Excel unless
you think file sizes several times larger are good. I for one generally
think HTML does a better job printing than Excel left strictly to it's own
devices for text data.

What PDF writer are you using, though I think they probably would
all produce the same results.