I have received a spreadsheet where the column headings are numbers and the row headings are also numbers. Can the column headings be changed back to letters? If so, how can I do this?
'=========================
Choose Tools > Options and select the General tab.
Remove the check mark from 'R1C1 reference style'
'=============================
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.