"Excel Pick List- What is it for?"

What is the Excel pick list feature? Maybe you are not familiarÂ…

Simple. It eases your data entry! When you needs to enter volume of data into Excel spreadsheet, ten this feature is a 'must-have' to use!

Let's see how it works.

To demonstrate the use of Excel pick list

  • Say you have entered the following data.
  • Excel 2007 data sheet

  • Right-click on the cell directly below the existing list.
  • Excel 2007 data sheet

Excel 2007 format cells color

  • Move your mouse over any of the colors and the cells will change automatically. You can then see what the new color looks like.
  • Click with the left mouse button to set the color you want. If you don't like any of the colors displayed, click on More Colors option.

Excel 2007 color dialog box

  • From the Colors dialog box displayed, choose a color and click OK.

To change the text color

  • Highlight the text that you want to change color.
  • From the Home tab, in the Font group, point to the Font Color icon.
  • Click the arrow just to the right of the Font Color icon. You'll see some colors appear.
  • Select a color just like you did for the background color of the cell.

Related Topics:

The Quick Method to Move One Place to Another in Excel 2007
How to Change the Excel 2007 Cell Color?
What you Can do with Excel 2007 Paste Special Feature?
Excel 2007 Help - Your Personal Virtual Assistant!

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel pick list info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb

Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!

PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007

What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.