« Rae Delfosse Oils and Watercolors Exhibit January - March 2008 | Main | Denise C. Williams "Denise's Creations" Exhibit January - March 2008 »

Microsoft Excel Tips

If you have taken Excel classes at the library, then you should have learned many of its features. For those of you wanting to learn a little bit more, here are some additional tips that you can add to your Excel knowledge.

CREATING CUSTOM LISTS
Remember how to do lists for the months of the year or the days of the week? You use auto-fill to do that, right? Well, you can also create your own custom fill lists. Just follow these steps.


  1. Go to Tools menu and select Options.

  2. Select the Custom Liststab.

  3. Type a list of entries in the List entries box, one entry per line, separating them by pressing the Enter key. You could also copy a list from a range of cells in your worksheet (if you have the data) by using the Import list form cells.

  4. Click Add to add the list and click OK to finish.

  5. Now type any entry from your list in a cell and drag the fill handle to create the sequence.


customlists.JPG

USING FORMS
Use form feature in Excel instead of navigating around a large table. Here's how to do it.


  1. Create your heading labels in your worksheet.

  2. Highlight your heading labels and go to Data menu and select forms. Click OK on the dialog box that will appear.

  3. Now you can enter data into your table using the Form dialog, which is quicker and more convenient. Click Close to finish.


REARRANGING DATA
One of the commands in the Data menu has a way of splitting information in a cell for easy re-sorting or reformatting. For example, if you have a list of full names and you want to sort it by last name you could split their contents by following these steps.


  1. Select your data.

  2. Go to the Data menu, and select Text to Columns.

  3. On the Convert Text to Columns Wizard, choose the file type that describe your data (we will use Deliminate) and click Next.

  4. In the list of Delimiters, click the Space checkbox and click on Next.

  5. The last wizard step will let you select each column and set the data format. Select the general data format and click on Finish.


names.JPG

Reference: www.pcmag.com

Keep checking our blog for more computer tips and tricks. Also, register for computer classes at any Orange County library. Remember these classes are free for Orange County residents.

For more information, call us at 407.835.7323 or check it out www.ocls.info

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Under Florida law, e-mail addresses are public records. If you do not want your e-mail address released in response to a public-records request, do not include your e-mail address in your comments. Instead, contact this office by phone or in writing.