Credit Card Info w/ Invoice Template

[Lab Man]

There is a pull down menu in the "Spreadsheet Solutions"
Invoice template for a Credit Card. The options read:
Credit Card #1, Credit Card #2, and Credit Card #3. How do
I enter the type of card i.e. Amex, Visa, etc. in place of
these 3 pull downs? I can't find any reference in the
template Help or in Excel Help. Thanks in advance for any
assistance!
Lab Man (Retreivers Rule!)

 

[magicalbob]

Lab Man,
Pull down menus are created through data validations. Go
to the cell with the pull down menu, then, in your
toolbar, go to data and validation. In the validation
window, it should tell you the range for the source cells
that contain your choices. These cells may be hidden. Then
go to the source cells and change them to the values that
you want, or add more. If you add more, remember to add
those cells to the source cell range in the validation
window.

Good luck.

 

[Lab Man]

-----Original Message-----
Lab Man,
Pull down menus are created through data validations. Go
to the cell with the pull down menu, then, in your
toolbar, go to data and validation. In the validation
window, it should tell you the range for the source cells
that contain your choices. These cells may be hidden. Then
go to the source cells and change them to the values that
you want, or add more. If you add more, remember to add
those cells to the source cell range in the validation
window.

Good luck.


.
Magical Bob,

Thanks for the tip. I'll work on it and hope that I can
accomplish my objective. It sounds a little confusing to
this novice, but I'll give it a try.
Regards,
Lab Man