ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why are my colums in excel numbered as well as the rows (https://www.excelbanter.com/excel-discussion-misc-queries/129259-why-my-colums-excel-numbered-well-rows.html)

Jazzy

Why are my colums in excel numbered as well as the rows
 
I have been looking at the use of formulas in excel, I do not use excel much
but all the formulas seem to need the column to be referenced with a letter.
For some reason my excel has numbers for rows and columns, can I change this,
if so how is it done.

RagDyeR

Why are my colums in excel numbered as well as the rows
 
<Tools <Options <General tab,
And *UNCHECK*
"R1C1 Reference Style".
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Jazzy" wrote in message
...
I have been looking at the use of formulas in excel, I do not use excel much
but all the formulas seem to need the column to be referenced with a letter.
For some reason my excel has numbers for rows and columns, can I change
this,
if so how is it done.



Gary''s Student

Why are my colums in excel numbered as well as the rows
 
Tools Options General and clear the R1C1 checkbox
--
Gary's Student
gsnu200704


"Jazzy" wrote:

I have been looking at the use of formulas in excel, I do not use excel much
but all the formulas seem to need the column to be referenced with a letter.
For some reason my excel has numbers for rows and columns, can I change this,
if so how is it done.



All times are GMT +1. The time now is 05:30 PM.

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