Drag letters the same as numbers
Is it possible to have Excel increment the letters of the alphabet in the same way it increments numbers, when you drag the fill handle?
By Neale Blackwood, 22 Dec 08
Yes, Excel's Custom List feature will allow you to do that. The easiest way to create a Custom list is to enter the letters of the alphabet in a column, one letter per cell going down the page. Select the range containing the letters and click the Tools menu click Options and select the Custom List Tab.
Click the Import button to create the list, then Click OK. In Excel 2007 click the Office button, click Excel Options, click Popular, click the Edit Custom Lists button, click Import and click OK. This technique could be used for the states of Australia or Branches in your business. If one of the entries of a custom list is in a cell and you drag that cell, Excel will enter the following entries from the list when you drag the fill handle. An added benefit of a Custom List is that you can us it to sort. When you use the Sort feature in Excel there is an Options button that allows you to choose a Custom List to sort by.
Note that a Custom List only resides on the computer it was created on.
First published: CPA AUSTRALIA Magazine INTHEBLACK October 2007 - Page 18 Excel Yourself
In Excel 2007 Custom Lists are accessed by selecting the round Office icon and selecting Excel Options. In the Popular section there is an Edit Custom Lists button.
Be the First to Comment!
|Sort Control - How can I sort in a specific order that isn't alphabetic or numeric?
Excel has a feature called custom list. To access this feature click the tools menu, then click options and select the customs list tab. This holds Excel's built-in lists ...
|Turning off Drag and Drop automatically - I have an input spreadsheet that I distribute to users. I have used sheet protection to ensure users can only change input areas. The problem is users are still able to drag and drop within the input areas, which causes #REF! errors. Is there a way to stop users dragging and dropping?
This solution works on Excel 97 and later versions. In the Tools menu under Options, in the Edit tab there is a check box to "Allow cell drag and drop" ...