Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL XP question... | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
[Q] Question on using Excel | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |