Microsoft Excel Question: Download Questions PDF
Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns?
Answer:
You have Excel set up to use the R1C1 style of cell notation. Go to Tools > Options. Pick the General Tab. The first box in the settings section is checked ("R1C1 reference style"). Uncheck this box. Click OK. Your problem should be solved.
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How can I copy the name of the worksheet tab to a cell in the worksheet? | I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash? |