Re Excel Toolbar

[Mo]

Can u please advise if i can change the numbers on the
excel sheet where the letters should be for some reason it
is showing numbers

 

[Norman Harker]

Hi "Mo"

Try:

Tools > Options > General
Remove check from R1C1 Reference Style
OK



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jenny Massey]

I am having this same problem, I have made the change,
but it will not stay - I have to do this each time I open
Excel. How do I get it to stay or to turn this feature
off.

Thanks!

 

[Norman Harker]

Hi Jenny!

Check for the existence of a Personal.xls file that is usually the
first to open

Use:

Window > Unhide

Select Personal.xls
Change the setting there
Save the File
Hide it again

If you don't have a Personal.xls then check all files in the Startup
directory. Use Tools > Options General to find that directory.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.