View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default new worksheet with 4 columns only

Whilst you make a worksheet look very different to a normal Excel worksheet,
it will still contain 256 columns and have columns labels as normal.
Record a macro whilst you hide all the other columns, add the required
headers and possible play with the settings on ToolsOptionsView.

NickHK

"Boba" wrote in message
...
Hi;
By default, my excel creates new worksheet with 256 columns
and column headings A, B, C, ...
I'd like to create a new worksheet with 4 columns only
and set the column headings to "Last","First","e-mail","Phone".
Thanks. Boba