Drag Letters The Same As Numbers

Client Success Stories

  • Chevron needed better reporting on its changing workforce and be able to present this information to management for decision-making. The information was stored in a variety of different systems and...... Read more »
  • Technip required a solution to secure detailed information on the inventory of parts that each of its suppliers can access to ensure project design specifications could be met for the Wheatstone...... Read more »
  • Acuity Coaching, a highly-regarded firm of business coaches, required a model that would allow their clients to conduct “what-if” analyses on a range of variables in their businesses to...... Read more »
  • Chevron Perth was required by its US head office to implement measures that would meet the Sarbanes-Oxley (SOX) Section 404 requirements.... Read more »
  • Staff in Leighton’s Perth Office needed a tool that would enable them to keep track of personnel capabilities and availabilities to enable them to design rosters to meet the requirements of the...... Read more »
  • The owners of Nubax required a flexible and user friendly financial model to present information to potential investors.... Read more »
  • The Council wanted to change the parking charges on its various car parks plus construct some new ones. As such, they needed to model a range of different scenarios to test which would result in an...... Read more »
  • One of their international mining projects required a feasibility study financial model to use for raising debt funding from the company’s financiers.... Read more »
  • A consultant worked with the business to design a range of strategic initiatives that would help the business trade out of difficulty and communicate this effectively to the bank. ... Read more »
  • TFS needed an investment model to help them compete effectively against other agribusiness investment schemes.... Read more »
  • As the result of a strategic review, the company wanted to implement a new accounting system, and redevelop its management reporting and budgeting systems.... Read more »
  • Terrex was rapidly expanding its business and the process of gathering time-keeping information from employee teams that were geographically dispersed, processing this, then uploading everything...... Read more »

Famous Quotes

  • "When defeat comes, accept it as a signal that your plans are not sound, rebuild those plans, and set sail once more toward your coveted goal." Napoleon Hill
  • "Some people see things as they are, and say 'Why?' I dream of things that never were, and say 'Why not?'" George Bernard Shaw
  • "The greatest businesspeople I've met are determined to get it right no matter what the cost." Michael E Gerber

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

Extras

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.

Print this article Print  E-mail this article EmailShare:

Related Articles

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" ...
Share This: