excel question....... please help
 

I am trying to setup on excel where you use shortcut keys to put in a
sentence. For example( by pushing Ctrl 1 the sentence '' 3days not sent "
shows up. Can some one please tell me if this is possible and if so how do
you do it?

excel question....... please help
 

Record a Macro. Assign the Ctrl combo to it.

jk wrote:

I am trying to setup on excel where you use shortcut keys to put in a
sentence. For example( by pushing Ctrl 1 the sentence '' 3days not sent "
shows up. Can some one please tell me if this is possible and if so how do
you do it?

excel question....... please help
 

You can use Macros. I don't know if it is the best way, especially if you
intend to have many inserts, but it will certainly work.

"jk" wrote:

I am trying to setup on excel where you use shortcut keys to put in a
sentence. For example( by pushing Ctrl 1 the sentence '' 3days not sent "
shows up. Can some one please tell me if this is possible and if so how do
you do it?

excel question....... please help
 

Another possibility is to create a special character sequence in Auto
Correct. See if this is usable for your purposes or not. Click on

Tools/AutoCorrect Options...

on Excel's menu bar, type (as an example) ..3 (that is dot-dot-3) in the
Replace field and put "3 days not sent" in the With field, and OK out of the
dialog box. Now type ..3 in any cell and hit the Enter, an Arrow Key or
Space Bar key to watch the ..3 change to your phrase. You can set up as many
of the as you want... just think of an easy beginning "code" (the dot-dot in
my example) to just for you phrases and some number and/or letter
combination that you will remember links to the phrase you want.

Rick


I am trying to setup on excel where you use shortcut keys to put in a
sentence. For example( by pushing Ctrl 1 the sentence '' 3days not sent "
shows up. Can some one please tell me if this is possible and if so how do
you do it?

excel question....... please help
 

Excellent idea - better than macros for this.

"Rick Rothstein (MVP - VB)" wrote:

Another possibility is to create a special character sequence in Auto
Correct. See if this is usable for your purposes or not. Click on

Tools/AutoCorrect Options...

on Excel's menu bar, type (as an example) ..3 (that is dot-dot-3) in the
Replace field and put "3 days not sent" in the With field, and OK out of the
dialog box. Now type ..3 in any cell and hit the Enter, an Arrow Key or
Space Bar key to watch the ..3 change to your phrase. You can set up as many
of the as you want... just think of an easy beginning "code" (the dot-dot in
my example) to just for you phrases and some number and/or letter
combination that you will remember links to the phrase you want.

Rick


I am trying to setup on excel where you use shortcut keys to put in a
sentence. For example( by pushing Ctrl 1 the sentence '' 3days not sent "
shows up. Can some one please tell me if this is possible and if so how do
you do it?