Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same text in various cells
If I want to insert the same text/number etc in many different cells but not
in any order e.g. A4 D5 F8 etc. What is the quickest way to do this NOT using copy/paste? Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same text in various cells
"Josh W" wrote:
If I want to insert the same text/number etc in many different cells but not in any order e.g. A4 D5 F8 etc. What is the quickest way to do this NOT using copy/paste? Excel 2003. Hold down CTRL then click to select all cells, which may be a mix of contiguous & discontiguous cells. Then click inside the formula bar, type the text, and press CTRL+ENTER. And if the selection of cells is always the same, you could also create a named range to save repetitive effort in re-selecting each time. To create the named range, after you have carefully selected all cells concerned, just click inside the namebox*, type a name, say: MyR, then press ENTER *dropdown just to the left of the formula bar, above col header "A" With the named range defined, just click on the namebox dropdown and select MyR, and the range will be auto-selected immediately. You could then proceed to either clear the range, or enter the text into the formula bar, press CTRL+ENTER, or format all at one go, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same text in various cells
Hi Josh,
If I want to insert the same text/number etc in many different cells but not in any order e.g. A4 D5 F8 etc. What is the quickest way to do this NOT using copy/paste? Excel 2003. Select the cells, type the text and hit control+enter. Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same text in various cells
Thanks Max, those were great tips!
"Max" wrote: "Josh W" wrote: If I want to insert the same text/number etc in many different cells but not in any order e.g. A4 D5 F8 etc. What is the quickest way to do this NOT using copy/paste? Excel 2003. Hold down CTRL then click to select all cells, which may be a mix of contiguous & discontiguous cells. Then click inside the formula bar, type the text, and press CTRL+ENTER. And if the selection of cells is always the same, you could also create a named range to save repetitive effort in re-selecting each time. To create the named range, after you have carefully selected all cells concerned, just click inside the namebox*, type a name, say: MyR, then press ENTER *dropdown just to the left of the formula bar, above col header "A" With the named range defined, just click on the namebox dropdown and select MyR, and the range will be auto-selected immediately. You could then proceed to either clear the range, or enter the text into the formula bar, press CTRL+ENTER, or format all at one go, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting the same text in various cells
Welcome. Do take a moment to press the "Yes" button below
from where you're reading this. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Josh W" wrote: Thanks Max, those were great tips! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting text from external file into cells. | Excel Discussion (Misc queries) | |||
Inserting an Item into cells with text | Excel Worksheet Functions | |||
Inserting text into numerous cells for many different files | Excel Discussion (Misc queries) | |||
Inserting cells between cells with text | Excel Discussion (Misc queries) | |||
Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) |