Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new worksheet with 4 columns only
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
new worksheet with 4 columns only
Hi Boba,
The number of columns is immutable but you could hide the unwanted columns.With the columns to hide selected: Format | Column | Hide You cannot uitilise user defined column headers. Perhaps, try inserting the desired headers on the first row and freeze the row: with cell A2 selected: Window | Freeze Panes --- Regards, Norman "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
new worksheet with 4 columns only
Thanks.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing a worksheet in two (or more) columns | Excel Discussion (Misc queries) | |||
Why can't I add rows or columns on my worksheet? | New Users to Excel | |||
I need to add columns at the end of a worksheet, | Excel Worksheet Functions | |||
How to merge columns from one worksheet to another worksheet | Excel Worksheet Functions | |||
VBA to show or hide columns in one worksheet conditioned on value in other worksheet | Excel Programming |