View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Question about Excel

go into tools=Autocorrect and put in your combinations.

--
Regards,
Tom Ogilvy

"Excel" wrote in message
...
I work for a construction company where we do a lot of bidding on

projects.
We have an excel spreadsheet of about 150 different categories that could

be
in a bid, but most of the time only 20 or so are used. However, every bid
consists of different categories. Instead of typing out the category

every
time, a co-worked told me that before they updated to Microsoft Office

2002,
she used to be able to type in (*02), or (*04), (*63), whatever no. the
category was that she wanted, and the category name would appear in the

cell.
She asked me if I could make it like that again because it was much

easier
on her. Does anyone know how to go about setting that up?