ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Return column letters to spreadsheet. (https://www.excelbanter.com/charts-charting-excel/32698-return-column-letters-spreadsheet.html)

Isidor

Return column letters to spreadsheet.
 
Somehow I no longer have column letters and row numbers on my spreadsheet.
How do I get them back?
--
Isidor Dordick

bj

<tools<options<General unclick R1C1 reference style.
It happens for various reasons ocassionally

"Isidor" wrote:

Somehow I no longer have column letters and row numbers on my spreadsheet.
How do I get them back?
--
Isidor Dordick


Jon Peltier

If that doesn't help, go to Tools menu - Options - View tab, and check
the Row and Column Headers box under Window Options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:

<tools<options<General unclick R1C1 reference style.
It happens for various reasons ocassionally

"Isidor" wrote:


Somehow I no longer have column letters and row numbers on my spreadsheet.
How do I get them back?
--
Isidor Dordick


bj

Thanks, I misread what he asked.

"Jon Peltier" wrote:

If that doesn't help, go to Tools menu - Options - View tab, and check
the Row and Column Headers box under Window Options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:

<tools<options<General unclick R1C1 reference style.
It happens for various reasons ocassionally

"Isidor" wrote:


Somehow I no longer have column letters and row numbers on my spreadsheet.
How do I get them back?
--
Isidor Dordick



Jon Peltier

No problem. Whoever read both replies learned two things, one for now
and one for later.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:
Thanks, I misread what he asked.

"Jon Peltier" wrote:


If that doesn't help, go to Tools menu - Options - View tab, and check
the Row and Column Headers box under Window Options.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


bj wrote:


<tools<options<General unclick R1C1 reference style.
It happens for various reasons ocassionally

"Isidor" wrote:



Somehow I no longer have column letters and row numbers on my spreadsheet.
How do I get them back?
--
Isidor Dordick




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

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