Publishing Excel 2007 Sheets as Web Pages

[schlagce]

I've got two questions regarding publishing Excel sheets as web
pages. For the record, I'm using Excel 2007.

I have some text in a cell that is aligned 90 degrees from
horizontal. When I publish this sheet as a web page, the alignment of
the text resorts to normal, horizontal alignment. However, I'm
looking to preserve the alignment I had in Excel when I publish the
page. Anyone know how to do this? I had seen this same question
posted on another site, but no one knew how.

Also, when I publish, the viewing area of the sheet extends beyond the
viewing area of my screen in my Web browser. (I'm using IE 7.0).
Does anyone know how to adjust either the IE settings or the Excel
settings so that the selected area will shrink down to fit the
screen? I'm not sure if I want to do that, but I'd at least like the
option to do so.

Thanks,
Scotty81

 

[Shane Devenshire]

Hi Scotty,

You will notice when you save as webpage that there is a message that some
feature may not be compatible with HTML format. There in lies the problem.
If the text is in a cell then you are applying an Excel format which won't
work in HTML.

You can get around this limitation by using a textbox, an autoshape,
WordArt, or by taking a picture of the rotated text using Copy Picture or
the Camera tool.

Cheers,
Shane Devenshire
Microsoft Excel MVP