"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.

• Right-click on the cell directly below the existing list.

• 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.

• 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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb