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
|