![2011 2011](/uploads/1/2/5/7/125715448/411065759.png)
![Microsoft excel for mac 2011 how to to back to first column when hitting enterprise Microsoft excel for mac 2011 how to to back to first column when hitting enterprise](http://www.techonthenet.com/excel/columns/images/unhide_cola2011_002.gif)
To change the column headings to letters, select Preferences. Under the Excel menu. 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. Excel will move the cursor from column to column until you reach the right-most column in the selection. At this point, when you press Enter, Excel will move the cursor to the left-most column in.
Deb is trying to AutoFill record numbers in a column of her worksheet; record 1 in the first cell, record 2 in the second cell, etc. The 'Enable Fill Handle' box is checked in Excel options. However, when she uses the AutoFill handle, it just pastes the same number in every cell. Deb is wondering how she can fix this.
Based upon the described behavior, it sounds like Deb is trying to use AutoFill to create a series (1, 2, 3, etc.) when she isn't giving AutoFill enough information to determine that is what she wants to do. For example, enter the value 1 into cell A1 and the value 2 into cell A2. If you select cell A2 and use the AutoFill handle to drag downward, what happens is that Excel fills each of the cells with the value 2. Why? Because you only started by selecting a single cell.
On the other hand, if you select cells A1:A2 and then drag down, AutoFill will increment the value placed into each of the cells. Why? Because it can analyze the information you started to enter in the cells and use it to determine how to fill the remaining cells with a series of values.
If, for some reason, you don't want to start with a selection of two cells, you could simply select one cell (A2) and hold down the Ctrl key as you drag the fill handle downward. AutoFill will override its normal determination (copy the selected value downward) by forcing a series of numbers into the filled cells.
If you're still having problems, make sure that your filters are clear. If filters are turned on, they may cause the same number to repeat, even when selecting more than one cell.