Loss of data on spreadsheet

B

Big L

Having saved an excel spreadsheet I reopened it to find the numbering of
cells down the left hand side of the spreadsheet and the letters at the top
of the spreadsheet had gone.
I don't know how it happened or more importantly how to het them back
 
S

Stefi

Tools>Options>General, uncheck R1C1 reference style!

Regards,
Stefi

„Big L†ezt írta:
 
J

Jacob Skaria

In XL2003: menus Tools>Options>General tab>R1C1 Reference style
In XL2007: Office Button>Excel Options> Formulas>'Working with formulas'>
R1C1 reference style

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get excel to open with cursor in same cell as when close 2
Spreadsheet appearing twice do not know why 2
Linking 2 spreadsheet using data from the last row of spreadsheet 13
Quote Marks Question 2
Linking 2 spreadsheet using data from 1st spreadsheet 1
My spreadsheet only appears in the top left of the page. 1
Finding Cell with Minor loss of fidelity 1
Can't view my spreadsheet data except in print preview 1

Top