Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I name the colums and rows?
I want to put a name into the colums where it says "A-Z". I need help on
doing this. Can you help? |
#2
|
|||
|
|||
If you mean the built in column headers there is no way except removing them
and fake lookalike headers in row1 Regards, Peo Sjoblom "Cin3" wrote: I want to put a name into the colums where it says "A-Z". I need help on doing this. Can you help? |
#3
|
|||
|
|||
Can't be done.
You can simulate this by hiding row and column headers (Tools/Options/View), then entering the values you want in A1:Z1. This won't change your cell references however (though you may be able to use the intersection operator - I don't). Then enter 1 in A2 and fill down as a series to simulate the row numbers. If you do this, select cell B2 and choose Window/Freeze Panes to keep the new column or row "headers" from scrolling. In article , "Cin3" wrote: I want to put a name into the colums where it says "A-Z". I need help on doing this. |
#4
|
|||
|
|||
You can't. Best you can do is put a heading in row 1. You could then hide
headings. -- HTH RP (remove nothere from the email address if mailing direct) "Cin3" wrote in message ... I want to put a name into the colums where it says "A-Z". I need help on doing this. Can you help? |
#5
|
|||
|
|||
JE McGimpsey wrote:
. . .you may be able to use the intersection operator - I don't.... OK, I'll bite. Why not? Alan Beban |
#6
|
|||
|
|||
In article ,
Alan Beban wrote: OK, I'll bite. Why not? Because handing a file that uses intersections over to my clients to maintain is generally a recipe for disaster. Especially if the specification calls for row or column headers using multiple words, e.g.: Heading 1 Heading 2 Heading 3 Row 1 1 2 3 Row 2 4 5 6 Row 3 7 8 9 seeing = Heading 2 Row 1 + Heading 1 Row 3 / Heading 3 Row 2 just doesn't make sense to them, somehow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
switch colums and rows | New Users to Excel | |||
Rows and columns | New Users to Excel |