View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Big-dog1965 Big-dog1965 is offline
external usenet poster
 
Posts: 4
Default 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