data validation

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data validation

Data validation

resolvedResolved · Low Priority · Version 2003

Luisa has attended:
Excel Introduction course

Data validation

How do I validate a group of cells to create a list

RE: Data validation

Hi Luisa,

Creating a custom list in Excel can either be undertaken by typing the items directly or extracting the information from a pre-created column of data.

Go to Tools>Options, from the tabs choose Custom Lists and in the list entries box type your items separated by a comma, if you wish to use a pre-created list click the Import list from cells box and select (highlight) the required information in your worksheet, click the Import button and your items will be displayed in the List entries box. click OK and you will be able to use the list at any time (using the Fill button or the Edit>Fill commands... Pete

Wed 10 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Create own ribbon tab - Excel 2010

a. In Excel click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.1 secs.