You can rename columns and rows via the Excel formula bar.
To rename a column or row in a worksheet:
- Select the cell for a column header, in this example "Q1 FY16."
The following formula displays:
=CHOOSE(2, "5423690091", "Q1 FY16")
- Change the value within the last set of quotation marks.
You can see the header name change as you type.