Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Publishing Excel 2007 Sheets as Web Pages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
schlagce@airproducts.com - 23 May 2008 19:27 GMT
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 - 24 May 2008 21:37 GMT
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

> I've got two questions regarding publishing Excel sheets as web
> pages.  For the record, I'm using Excel 2007.
[quoted text clipped - 15 lines]
> Thanks,
> Scotty81
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.