#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 460
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 345
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding Header Columns abc... in 2007 Debbiejj Excel Discussion (Misc queries) 1 July 8th 09 10:11 PM
Rename columns header from Alphabet to Numeric Seagull Excel Discussion (Misc queries) 1 August 30th 06 05:02 PM
How do I create and name header rows and columns? R9166 New Users to Excel 3 August 30th 05 02:48 AM
sort columns within a merged cell header Diana Excel Discussion (Misc queries) 1 August 4th 05 11:03 PM
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. bro. Billy New Users to Excel 4 December 11th 04 12:01 AM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"