ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding Column Heading w/o Using a Row Number (https://www.excelbanter.com/excel-discussion-misc-queries/120260-adding-column-heading-w-o-using-row-number.html)

NBrown

Adding Column Heading w/o Using a Row Number
 
I want to add headings to my columns starting with row 1, etc., but I need to
add column headings above row 1. I want my worksheet to be formatted so that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?

Bernard Liengme

Adding Column Heading w/o Using a Row Number
 
In a word (or 2): you can't
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"NBrown" wrote in message
...
I want to add headings to my columns starting with row 1, etc., but I need
to
add column headings above row 1. I want my worksheet to be formatted so
that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?




David Biddulph

Adding Column Heading w/o Using a Row Number
 
.... but you can insert a new column A, and put your pseudo row numbers in
there. You can switch off the display of normal row & column headers
through Tools/ Options/ View ... (and use Freeze pains to show your
pseudo-headings, if you so wish).
--
David Biddulph

"Bernard Liengme" wrote in message
...
In a word (or 2): you can't
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"NBrown" wrote in message
...
I want to add headings to my columns starting with row 1, etc., but I need
to
add column headings above row 1. I want my worksheet to be formatted so
that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?






NBrown

Adding Column Heading w/o Using a Row Number
 


"NBrown" wrote:

I know how to add headings to my columns starting with row 1, etc., but I need to
add column headings above row 1. I want my worksheet to be formatted so that
all column headings are on unnumbered rows with row 1 of the worksheet
appearing below the column headings. How do I do this?



All times are GMT +1. The time now is 07:17 AM.

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