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
|