ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Change Column gridlines headings A,B,C.....versus 1,2,3.... (https://www.excelbanter.com/setting-up-configuration-excel/170792-change-column-gridlines-headings-b-c-versus-1-2-3-a.html)

MS_COS-LLC

Change Column gridlines headings A,B,C.....versus 1,2,3....
 
Accidentally change column gridline headings to 1,2,3....how do I change grid
for columns back to A,B,C.....

Dave Peterson

Change Column gridlines headings A,B,C.....versus 1,2,3....
 
In xl2003:
Tools|Options|General Tab|uncheck R1C1 reference style



MS_COS-LLC wrote:

Accidentally change column gridline headings to 1,2,3....how do I change grid
for columns back to A,B,C.....


--

Dave Peterson


All times are GMT +1. The time now is 02:42 AM.

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