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.
- Go to Tools menu and select Options.
- Select the Custom Liststab.
- 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.
- Click Add to add the list and click OK to finish.
- Now type any entry from your list in a cell and drag the fill handle to create the sequence.
Use form feature in Excel instead of navigating around a large table. Here's how to do it.
- Create your heading labels in your worksheet.
- Highlight your heading labels and go to Data menu and select forms. Click OK on the dialog box that will appear.
- Now you can enter data into your table using the Form dialog, which is quicker and more convenient. Click Close to finish.
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.
- Select your data.
- Go to the Data menu, and select Text to Columns.
- On the Convert Text to Columns Wizard, choose the file type that describe your data (we will use Deliminate) and click Next.
- In the list of Delimiters, click the Space checkbox and click on Next.
- The last wizard step will let you select each column and set the data format. Select the general data format and click on Finish.
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