I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns?
I have just changed laptops and now excel shows its cell references as R1C1
for cell A1 how do i make it use letters for collumns?
Tools -> Options -> General and uncheck the R1C1 display
"Ian Hunt" wrote:
> I have just changed laptops and now excel shows its cell references as R1C1
> for cell A1 how do i make it use letters for collumns?
Go to Tools > Options. General Tab. Uncheck the box that
reads "R1C1 reference style".
HTH
Jason
Atlanta, GA
>-----Original Message-----
>I have just changed laptops and now excel shows its cell
references as R1C1
>for cell A1 how do i make it use letters for collumns?
>.
>
Tools>options>general and uncheck R1C1 reference style
--
Regards,
Peo Sjoblom
"Ian Hunt" <Ian [email protected]> wrote in message
news:[email protected]...
> I have just changed laptops and now excel shows its cell references as
R1C1
> for cell A1 how do i make it use letters for collumns?
Hi Ian,
Go into Tools, Options and the General Tab. In there untick the R1C1
reference style. This should then solve your problem.
Chris
"Ian Hunt" wrote:
> I have just changed laptops and now excel shows its cell references as R1C1
> for cell A1 how do i make it use letters for collumns?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks