How to set R1C1 citation style in Microsoft Excel - Method to set R1C1 citation style

Many people don’t know how to set the R1C1 citation style in Microsoft Excel? The article brought to you today is about Microsoft If you still don’t know how to set the R1C1 reference style in Excel, let’s learn it with the editor.

Step 1: First, we open the Excel table and click on the file in the upper left corner (as shown in the picture).

Step 2: Then we find "Options" in the file (as shown in the picture).

Step 3: Then we click "Formula" to enter (as shown in the picture).

Step 4: Find "R1C1 Reference Style" on the formula settings page (as shown in the figure).

Step 5: Check "R1C1 Reference Style" in the Use Formula menu (as shown in the picture).

Step 6: Finally, we just click OK below (as shown in the picture).

The above is the entire content of how to set the R1C1 reference style in Microsoft Excel brought to you by the editor. I hope it can help you.