How to update the label of the column header in an excel 2007 table.

  • Thread starter Thread starter easycapital
  • Start date Start date
E

easycapital

Example. A1="Name"

My table headers one is pointing to A1 so that it states "Name".

I have to been able to accomplish this. I want to link my column
headers for the table to names I have places outside.

Thanks,
JP
 
Please define "outside".

Basically you can set up a cell to link to almost any cell in any other
workbook. Easiest way is to let Excel do the work. Start by opening any/all
other workbooks that may have labels you want to use.

Go back to the workbook with your table and headers sheet in it and choose a
header cell and simply type the = symbol in the cell, then choose other
workbook(s), worksheet(s), cell(s) as needed to bring the label into that
workbook. Repeat for each cell you want a header label in. Even when you
close the other workbooks, the labels will remain and will be changed if the
contents of those linked cells change in the other workbooks/worksheets/cells.
 
Back
Top