Autofill/Autocorrect

[joeldsmt]

Hello,

In MSWord you are able to set the auto correct function to type in a
few lines of information when a certain letter or string of letters is
entered. Excel has this function but it is limited to one line(or at
least that is what i see).

Is there any way for me to just enter ABC and it display my company
address everytime i do so?

When i setup the autocorrect, all i get is the first line. Nothing
else.

Any ideas would be greatly appreciated.

Thank you very much
Joel

 

[Dave Peterson]

I don't think that this is autocorrect in MSWord--something like autotype???

Maybe you could use:

ABC replace with ABC$Company$whatever$you$want

Then let autocorrect change to the long on line text, then you could do
Edit|replace
what: $
with: ctrl-j
replace all

Use a character that's nice and unique so you don't "fix" the real $.

(or be very selective when you select your range.)

 

[joeldsmt]

Will this automatically add the 4 lines of address that i want entered?

JM

 

[Dave Peterson]

Maybe...

It'll fill the cell with text that will wrap to 4 lines. Not 4 separate cells.

 

[joeldsmt]

Thank you...

Will i be able to do this on any new spreadsheet or do i need to set it
up everytime?

 

[Dave Peterson]

If you use autocorrect, then it stays with the pc--but it'll be available for
all the workbooks that you open on that pc.

 

[joeldsmt]

I cant get this to work. I do appreciate your help but is there anyway
you can explain it a bit more?

Thank you in advance.

 

[Dave Peterson]

What part?

Did you get the entry added to the Autocorrect list?

Did the autocorrection actually take place?

Or was it the edit|replace that you had trouble with?

 

[joeldsmt]

It was the edit|replace part that i got lost.

 

[Dave Peterson]

Select your cells (at least two--even if one is empty).

Edit|replace
what: $ (or whatever character you used)
with: hit and hold the control key while hit the j key
click on Replace all

It may not look like anything went into that "with" box, but it you look close,
you'll see a difference--and try it--you'll see that it works.

 

[joeldsmt]

That worked. Thank you Dave.