| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding colums when saving as html
I have a speed sheet that I update and save as html on a weekly bases. It has
several colums that are not used all the time. I would like to hide the unused colums then save as html, but Ive tried the hide and when I save it it only shows the last 2 colums on the sheet. the colums I want to hide are like F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB. When I open in excel I dont want the colums hidden just hidden in the saved html file. How do I make this happen. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding colums when saving as html
In xl2003 menus, you can make a couple of custom views.
With all the columns showing: View|Custom Views|add a new view named Normal Hide the columns you want View|Custom Views|add a new view named ForHTMLSave Then just show/hide the view you want when you want. Big-dog1965 wrote: I have a speed sheet that I update and save as html on a weekly bases. It has several colums that are not used all the time. I would like to hide the unused colums then save as html, but Ive tried the hide and when I save it it only shows the last 2 colums on the sheet. the colums I want to hide are like F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB. When I open in excel I dont want the colums hidden just hidden in the saved html file. How do I make this happen. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding colums when saving as html
how do I do the custom view for whole work book or do I have to create custom
views for each sheet "Dave Peterson" wrote: In xl2003 menus, you can make a couple of custom views. With all the columns showing: View|Custom Views|add a new view named Normal Hide the columns you want View|Custom Views|add a new view named ForHTMLSave Then just show/hide the view you want when you want. Big-dog1965 wrote: I have a speed sheet that I update and save as html on a weekly bases. It has several colums that are not used all the time. I would like to hide the unused colums then save as html, but Ive tried the hide and when I save it it only shows the last 2 colums on the sheet. the colums I want to hide are like F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB. When I open in excel I dont want the colums hidden just hidden in the saved html file. How do I make this happen. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding colums when saving as html
Seems like a pretty easy thing to test.
Use a test workbook if you don't want to take a chance on your real workbook. Big-dog1965 wrote: how do I do the custom view for whole work book or do I have to create custom views for each sheet "Dave Peterson" wrote: In xl2003 menus, you can make a couple of custom views. With all the columns showing: View|Custom Views|add a new view named Normal Hide the columns you want View|Custom Views|add a new view named ForHTMLSave Then just show/hide the view you want when you want. Big-dog1965 wrote: I have a speed sheet that I update and save as html on a weekly bases. It has several colums that are not used all the time. I would like to hide the unused colums then save as html, but Ive tried the hide and when I save it it only shows the last 2 colums on the sheet. the colums I want to hide are like F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB. When I open in excel I dont want the colums hidden just hidden in the saved html file. How do I make this happen. -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding colums when saving as html
Thanks got it working
"Dave Peterson" wrote: Seems like a pretty easy thing to test. Use a test workbook if you don't want to take a chance on your real workbook. Big-dog1965 wrote: how do I do the custom view for whole work book or do I have to create custom views for each sheet "Dave Peterson" wrote: In xl2003 menus, you can make a couple of custom views. With all the columns showing: View|Custom Views|add a new view named Normal Hide the columns you want View|Custom Views|add a new view named ForHTMLSave Then just show/hide the view you want when you want. Big-dog1965 wrote: I have a speed sheet that I update and save as html on a weekly bases. It has several colums that are not used all the time. I would like to hide the unused colums then save as html, but Ive tried the hide and when I save it it only shows the last 2 colums on the sheet. the colums I want to hide are like F,G,H N,O,P V,W,X AD,AE,AF, AL,AM,AN AT,AU,AV the last 2 colums are BA and BB. When I open in excel I dont want the colums hidden just hidden in the saved html file. How do I make this happen. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| specify each sheet name when saving workbook as html | Excel Discussion (Misc queries) | |||
| saving ppt as html | Excel Discussion (Misc queries) | |||
| saving as HTML page | Excel Discussion (Misc queries) | |||
| Saving in html | Links and Linking in Excel | |||
| Saving in html | Excel Discussion (Misc queries) | |||
Linear Mode
