ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Somehow column headers changed to #'s, how do you change back? (https://www.excelbanter.com/excel-worksheet-functions/205272-somehow-column-headers-changed-s-how-do-you-change-back.html)

Sally Morgan

Somehow column headers changed to #'s, how do you change back?
 

--
Sally

muddan madhu

Somehow column headers changed to #'s, how do you change back?
 
tools | options | general tab | uncheck r1c1 reference style option |
ok




On Oct 6, 11:26*pm, Sally Morgan
wrote:
--
Sally



Sean Timmons

Somehow column headers changed to #'s, how do you change back?
 
Highlight them and Formet as General. then, highlight your workbook and
resize them to ensure they fit the column size.

"Sally Morgan" wrote:


--
Sally



All times are GMT +1. The time now is 04:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com