ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Loss of data on spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/244799-loss-data-spreadsheet.html)

Big L

Loss of data on spreadsheet
 
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

Stefi

Loss of data on spreadsheet
 
ToolsOptionsGeneral, uncheck R1C1 reference style!

Regards,
Stefi

€˛Big L€¯ ezt Ć*rta:

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


Jacob Skaria

Loss of data on spreadsheet
 
In XL2003: menus ToolsOptionsGeneral tabR1C1 Reference style
In XL2007: Office ButtonExcel Options Formulas'Working with formulas'
R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Big L" wrote:

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


David Biddulph[_2_]

Loss of data on spreadsheet
 
Tools/ Options/ View/ Row & column headers
--
David Biddulph

"Big L" <Big wrote in message
...
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





All times are GMT +1. The time now is 11:56 AM.

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