HJDS Computer Services Computer Systems Support and Installation.

Excel’s AutoFill feature is based on the program’s ability to spot patterns in the data that you enter. For example, if you type “Week 1″ in a given cell, you can have Excel automatically fill in “Week 2″, “Week 3″, etc. simply by dragging the AutoFill handle. This is to be found in the bottom right of the cell. If the cursor moves over it, the cursor changes appearance to a plus sign (+). When it changes you simply click, hold, drag in any direction and Excel will spot the pattern and maintain it to generate automatic data entries.

Whenever you make use of the AutoFill handle Excel displays the AutoFill Options drop down menu below the last cell which has been generated. If the program has not entered the required data, you can choose one of the entries in the AutoFill Options so that it knows what you actually meant it to do. For example, choosing Copy Cells, gives you an exact copy of what was in the original cell.

Excel is also capable of automatically entering an arbitrary series of data using a feature called Custom Lists. There are certain lists built into Excel, for example, the months of the year. To use the AutoFill feature, you need to enter the first value in the list, for example, “January” or “Jan”. Next, you drag the AutoFill handle (located in the bottom right of the cell) in any direction to have Excel automatically enter the rest of the custom list.

As well as these built-in lists, Excel allows you to create your own custom lists. For example, suppose you work for a company that has branches in several towns. It’s a safe bet that you’ll need to list these towns quite frequently in your spreadsheets. You could therefore save yourself considerable time by setting up the towns as a custom list.

To create a custom list, simply select some cells that contain the information. Next, choose Excel options by clicking on the Office button. Click “Edit Custom Lists” in the “Popular” tab. Excel lists the contents of the cells that were highlighted. To set up the selected data as a custom list, simply click on the “Import” button.

This custom list can now be used in any of our worksheets, not just the sheet that contained the original information. Whenever we need out list, we simply type the first value. We then use the AutoFill handle to generate the remaining entries. When using AutoFill, you can drag in any direction and you don’t have to start with the first element in the custom list.

You can also create custom lists directly in the “Custom Lists” dialog box. Simply click on the “List Entries” button and enter the elements separated by a carriage return. When you have finished entering your list, click on the Add button.

To delete a custom list, simply highlight its name and click on the “Delete” button. Excel checks to see that you really want to delete it. When you click “OK”, the list is permanently deleted.

Posted under Software

Everybody has individual needs and purposes for their iPhones. In conjunction with this everybody has their own favorite software and applications. Sometimes an item becomes so popular that many people want to take advantage of it. This is what often happens with the iPhone software.

Ebuddy: As mentioned there are many favorites, but probably first in line would be the Ebuddie. Its terrific, because now you can instant message or talk with whoever you want, just like you would do on your computer. There would be very little argument that Ims are one of the most popular items on the computer, so it makes sense that it would be on the iPhones as well.

Izoho: For business persons and students alike the most impressive iPhone software that they enjoy is Izoho. Its really neat because you can review any spreadsheets or notes that you need easy access to. Great for that last minute exam cramming that so many students engage in.

iPhonegas: With the cost of gas rising to unbelievable prices, there is little wonder of the popularity that the iPhone gas application is gaining, and is sure to gain in the future. Its amazing that all you have to do is enter your zip code and up comes a list of the cheapest gas stations near you. Its quick and easy and look at the gas you’ll save from not having to drive around looking for the best gas bargains.

One Trip Shopping List: As we have found in the iPhone games there is something for everybody. The same applies for the iPhone software. This is evident from the ones we have already talked about. Then just when you think that there is just nothing else available, that could make all your chores convenient, out comes the one trip shopping list. How many times have many of us been on the way home from work, and decided to drop off at the grocery store. Only problem is, we left the shopping list on the kitchen counter, when we left this morning. That is no longer a problem with the one trip shopping list. Its all there conveniently located on our iPhone.

When you start looking as to what is available in software and applications for the iPhones you are going to discover a whole new world. If you have reached a point where you ‘I wish” for something that would make your daily responsibilities a little easier, just start checking out what’s available for the iPhone. Its very likely you will find something very close to what you need.

You will be pleasantly surprised to find much of the iPhone software that is available, to be very reasonably price. In some case you can even get it for free. If you are new to iPhones, don’t miss out on all they have to offer, and what you can have to go with them. Any of the applications you are interested in will give you full instructions on how to download them and how to use them.

Posted under Software

In the long run we shape our lives and we shape ourselves. The process never ends until we die. The choices we make our own responsibility.

Posted under Twitter post