Instead, rename them using Excel's formula bar. Click "View" in Excel's ribbon. Check the box marked "Formula Bar" in the Show group. Click the cell of the column header that you want to rename.

Taking this step also reduces the file's size, so it's a good way ... There are three ways to rename worksheets in Excel. The quickest and easiest way is to double-click a worksheet tab, and ...