Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I just discovered the 'amazing feature' of being able to convert entire
Excel documents to Web pages. ;-) Undoubtedly this will save me about a hundred hours on a project I'm currently working on. For the time being I have just one question though. When converting the document all the formats I apply convert to the Web except the color of the worksheet tabs. Since the color of the tabs in my documents define groups or sections, it would be nice to have this format carry through to the Web. Any suggestions? Also, if it can't be fixed during the initial conversion, can I edit it after? Time consuming, yes, but better than doing the whole thing from scratch. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm betting that even if you can edit the created file you won't want to -
generally the HTML generated by office apps is an absolute nightmare of twisty little paths and little twisty paths. This is pretty much a WYSIWYG situation. You might consider other visual indicators to identify groups and sections, such as the manner in which you actually name the tabs, like Grp1-Sheet1 | Grp1-Sheet2 | Section B-Sheet 44 ...etc Keep in mind that you've only got 32 characters to use for sheet names. "James E Middleton" wrote: I just discovered the 'amazing feature' of being able to convert entire Excel documents to Web pages. ;-) Undoubtedly this will save me about a hundred hours on a project I'm currently working on. For the time being I have just one question though. When converting the document all the formats I apply convert to the Web except the color of the worksheet tabs. Since the color of the tabs in my documents define groups or sections, it would be nice to have this format carry through to the Web. Any suggestions? Also, if it can't be fixed during the initial conversion, can I edit it after? Time consuming, yes, but better than doing the whole thing from scratch. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Well don't get too used to the features, the same capabilities did not make
its way into the 2007 Excel or any other Office program for that matter. -- William<"M" Using 2007 "James E Middleton" wrote: I just discovered the 'amazing feature' of being able to convert entire Excel documents to Web pages. ;-) Undoubtedly this will save me about a hundred hours on a project I'm currently working on. For the time being I have just one question though. When converting the document all the formats I apply convert to the Web except the color of the worksheet tabs. Since the color of the tabs in my documents define groups or sections, it would be nice to have this format carry through to the Web. Any suggestions? Also, if it can't be fixed during the initial conversion, can I edit it after? Time consuming, yes, but better than doing the whole thing from scratch. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying formats - column widths, formats, outlining to worksheets | Excel Worksheet Functions | |||
Excel Date Formats | Excel Discussion (Misc queries) | |||
Time formats in Excel | Excel Discussion (Misc queries) | |||
Excel cell formats | Excel Discussion (Misc queries) | |||
Excel conditional formats | Excel Discussion (Misc queries) |