| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofill/Autocorrect
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 -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill/Autocorrect
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 wrote: 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 -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill/Autocorrect
Will this automatically add the 4 lines of address that i want entered? JM -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill/Autocorrect
Maybe...
It'll fill the cell with text that will wrap to 4 lines. Not 4 separate cells. joeldsmt wrote: Will this automatically add the 4 lines of address that i want entered? JM -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill/Autocorrect
Thank you... Will i be able to do this on any new spreadsheet or do i need to set it up everytime? -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autofill/Autocorrect
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 wrote: Thank you... Will i be able to do this on any new spreadsheet or do i need to set it up everytime? -- joeldsmt ------------------------------------------------------------------------ joeldsmt's Profile: http://www.excelforum.com/member.php...o&userid=11889 View this thread: http://www.excelforum.com/showthread...hreadid=507371 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
