changing column names

  • Thread starter Thread starter eyecalibrate
  • Start date Start date
E

eyecalibrate

I need to change the column names so I can tell where I'm at as I scrol
down through the rows. I have several macros running and I can't hav
this action change the cell addresses. It's probably a simple one bu
I've become frustrated.

Thanks,

Davi
 
You can't change the column headers (A, B, C), but
you can freeze the first row

Freeze first row
select row 2 then Window, Freeze Panes

Freeze first row and first 2 columns
select cell C2 (one row past, one column past), window, freeze panes

More information including doing similar for printing.
http://www.mvps.org/dmcritchie/excel/freeze.htm
 
Back
Top