View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default How to rename a column title in excel?

You can put titles that you want to see on row 1
and column A, then hide the column and row headers,
file, page setup, sheet, hide row and column headers
then you can fake the row numbers by placing =ROW()-1 into cell B2,
which might be fine for a report, but it would be a big pain to
maintain as an Excel file.
--
David McRitchie, Microsoft MVP - Excel

"Chip Pearson" wrote in message ...
If you mean to change the "A", "B", "C" column headers, you
can't.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"atta" wrote in message
...
How to rename a column title in excel?