This Excel tutorial explains how to change column headings from numbers (1, 2, 3, 4) back to letters (A, B, C, D) in Excel 2011 for Mac (with screenshots and step-by-step instructions).
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, my Excel spreadsheet has numbers for both rows and columns. How do I change the column headings back to letters such as A, B, C, D?
Answer: Traditionally, column headings are represented by letters such as A, B, C, D. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps.
The Microsoft Office 365 Backstage view is your one-stop-shop feature to see all the things you can do to any document you create. You access the Backstage view from the File menu. From there, various commands give you one-click access to more information about your document. You can see your document’s properties with Info, view. You can change the default author name in Excel by following the procedure described below. How to Change The Default Author Name in Excel To change the default another name, open Excel and Click on the File menu Excel Options. Next, go to the General section and scroll to Personalize your copy of Microsoft Office.
Change the font of row and column headings with Fonts feature. In Excel, you can also apply the Fonts feature under Page Layout to change only the font of the row and column headings. Click Page Layout, and in the Themes group, click Fonts and choose one font you like from the drop down list. If you want to change the title of the file then click on the ‘Add a title’ text shown in front of the Title Label and it will change into a textbox. Just enter the new value to give a title to the file. Similarly other values can be changed. Setting a default Excel template on the Mac. The process for setting a default Excel template on a Mac is similar to the steps above for Windows. Again, confirming the startup folder can be tricky, depending on whether y ou have Excel 2011 or 2016 installed (2008 not tested). In Excel 2016, according to Microsoft, there is currently no startup.
In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel. When the column headings are numeric values, R1C1 reference style is being displayed in the spreadsheet.
To change the column headings to letters, select Preferences.. under the Excel menu. Guide to small business networking in atlanta ohio.
When the Excel Preferences window appears, click on the General option under Authoring.
When the General window appears, uncheck the option called 'Use R1C1 reference style' and click on the OK button.
How To Change The Backstage Title For Excel On Mac Free
Now when you return to your spreadsheet, the column headings should be letters (A, B, C, D) instead of numbers (1, 2, 3, 4).