Why is Microsoft Excel displaying all my rows and columns with numbers instead of the standard R1C1 reference? I tried changing the settings back to the default by clicking on Tools – Options and selecting R1C1 reference style under the General tab, however, this didn’t make a difference. Does Excel have a similar Normal.dot default document template or are there command line options to repair the Excel template? As a temporary solution I opened a previously saved Excel file with R1C1 row/ column references and this seems to have corrected the problem, but I’m still stumped and quite baffled as to how this problem started.
© 2021 Leonard Nelson. All Rights Reserved. The content on this site reflects my own personal opinion and does not represent the views of any other individual or organization. All suggestions, solutions, advice and opinions come as-is with no warranty or responsibility implied.