Changing a default and using "racks"

[Guest]

Happy Friday!

I have a couple of questions:

1. How do I change a default in a list from "SST" to say "Green" (if the
user types in SST in the cell, I want the word "Green" replaces it
automatically)?

2. If there is a spreadsheet with "racks", how do I create additional
racks? I've never heard of or used racks so this is new to me.

I thank you in advance for your prompt response.

 

[Bernard Liengme]

1) use Tools |Autocorrect but this will apply to all Office docs opened on
that computer and will not apply if the XL file is placed on another PC.
Someone may give you a VBA solution.

2) Never heard of 'racks' in the workbook context.

best wishes

 

[Guest]

Thanks Bernard, it didn't do exactly what I asked so I think you are right
that it may need a VBA solution, thanks again and have a great weekend.

Rhonda