Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up number of yes, no, maybes in a column | Excel Worksheet Functions | |||
Adding number to each cell in a column | Excel Discussion (Misc queries) | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) |