Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header Columns
How do I have separate column widths in a spreadsheet? I wish to insert a
legend in the spreadsheet header and freeze frame it, but I wish for the body to have columns of different widths. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header Columns
Doug select cells A1 & A2 then Format Cells Alignment and tick Merge cells
Use the paste brush to copy down or across the sheet as far as you wish. You can use this 'merge' anywhere but use carefully as it can give you problems with copypaste and with formulae. Hope this helps "Doug" wrote: How do I have separate column widths in a spreadsheet? I wish to insert a legend in the spreadsheet header and freeze frame it, but I wish for the body to have columns of different widths. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header Columns
Usually best to avoid merging cells. You may find that the alignment option
"Cernter across selection" will do the trick, and it is a lot less troublesome. -- David Biddulph "Ron@Buy" wrote in message ... Doug select cells A1 & A2 then Format Cells Alignment and tick Merge cells Use the paste brush to copy down or across the sheet as far as you wish. You can use this 'merge' anywhere but use carefully as it can give you problems with copypaste and with formulae. Hope this helps "Doug" wrote: How do I have separate column widths in a spreadsheet? I wish to insert a legend in the spreadsheet header and freeze frame it, but I wish for the body to have columns of different widths. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Header Columns abc... in 2007 | Excel Discussion (Misc queries) | |||
Rename columns header from Alphabet to Numeric | Excel Discussion (Misc queries) | |||
How do I create and name header rows and columns? | New Users to Excel | |||
sort columns within a merged cell header | Excel Discussion (Misc queries) | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel |