Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Excel

sometime the letters change into numbers at the top of the worksheet, why and how to return to letters

RE: excel

Hi Salvatore

Thanks for getting in touch. Excel has gone into "R1C1" mode. This is an option you can set so Excel becomes more compatible with other spreadsheet programmes.

You can set and unset this by going to the Office button > Excel Options > Formulas and making sure the "R1C1 reference style" box is checked.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 20 May 2014: Automatically marked as resolved.

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.