Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Change cell refrence names for whole column/row
I have following spreadsheet
A B C 1 2 Project Type Sub-type 3 4 Can i somehow rename whole column name from A to proj, from B to type from C to stype to be able to reference these cells bb new defined names? For example i could then refrence to cell A3 as Proj3 or C4 as stype4? |
#2
|
|||
|
|||
Almost
.. First, name the columns: select the headers plus all of the column (at least, as far as you need). InsertNameCreate, check Top row Now apply Excel's other addressing system: ToolsOptionGeneral, check R1C1 Reference style Now you can refer to Project R4 (note the space before R4: the space is the Intersection operator) If you don't like to change to the other reference style, the reference would be Project $2:$2 But it would be even better to define names for the rows as well, and use both names and the intersection operator -- Kind regards, Niek Otten Microsoft MVP - Excel "Mikus" wrote in message ... I have following spreadsheet A B C 1 2 Project Type Sub-type 3 4 Can i somehow rename whole column name from A to proj, from B to type from C to stype to be able to reference these cells bb new defined names? For example i could then refrence to cell A3 as Proj3 or C4 as stype4? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) |