ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Codes (https://www.excelbanter.com/excel-discussion-misc-queries/157822-codes.html)

Sam

Codes
 
We have lots of service codes where we would like to be able to type a
service code into a and then have multiple lines of text (the actual
description of the service) insert into that same cell when we press enter
(Ex. we type "xyz" and the text "so on and so forth" actual enters into the
cell. How would we do that?

bj

Codes
 
if it is not a lot of text, try adding to the tools-autocorrect
options-autocorrect list

"sam" wrote:

We have lots of service codes where we would like to be able to type a
service code into a and then have multiple lines of text (the actual
description of the service) insert into that same cell when we press enter
(Ex. we type "xyz" and the text "so on and so forth" actual enters into the
cell. How would we do that?


JE McGimpsey

Codes
 
One way:

Tools/Autocorrect

In article ,
sam wrote:

We have lots of service codes where we would like to be able to type a
service code into a and then have multiple lines of text (the actual
description of the service) insert into that same cell when we press enter
(Ex. we type "xyz" and the text "so on and so forth" actual enters into the
cell. How would we do that?



All times are GMT +1. The time now is 11:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com