ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Headings (https://www.excelbanter.com/excel-discussion-misc-queries/16705-column-headings.html)

spencer4hire

Column Headings
 
Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
I'm attempting to alter the column sizes half-way through the spreadsheet
w/out affecting the upper column sizes...

Gord Dibben

Coolumn width belongs to the entire column and cannot be altered in separate
sections of that column.


Gord Dibben Excel MVP


On Tue, 8 Mar 2005 15:51:01 -0800, spencer4hire
wrote:

Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
I'm attempting to alter the column sizes half-way through the spreadsheet
w/out affecting the upper column sizes...



Dave Peterson

You can type anything you want in those cells.

Maybe put letters in and give them a grey fill color???

And columnwidths are associated with columns. So you can't have different
columnwidths for different rows.

But you can use mergedcells to give it the appearance that you want. But be
aware that merged cells make lots of things tougher to do. I'd stay away from
them if I had a choice.

Is there some reason, you can't put the other stuff on a different worksheet?

I find this much easier for updates and such.

spencer4hire wrote:

Can you add seperate column headings (A, B, C, ...) into one spreadsheet?
I'm attempting to alter the column sizes half-way through the spreadsheet
w/out affecting the upper column sizes...


--

Dave Peterson


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com