By adjusting a setting in the Excel Options dialog box, you can revert back to the default setting of column header which is ABC...
To change the setting, perform the following steps:
1. Click the Microsoft Office button and click Excel Options.
2. In the Excel Options dialog box, in the left pane click Formulas. In the right pane, under Working with formulas, click to remove the check mark besides R1C1 reference style.
3. Click OK to close the Excel Options dialog box.
To change the setting, perform the following steps:
1. Click the Microsoft Office button and click Excel Options.
2. In the Excel Options dialog box, in the left pane click Formulas. In the right pane, under Working with formulas, click to remove the check mark besides R1C1 reference style.
3. Click OK to close the Excel Options dialog box.
0 comments:
Post a Comment