Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Repeat Data
Dear Expert,
My data patern D, D, N, N, O, O, O, R . If I type D in a1 I want next to follow with the rest of the pattern and repeat the same patern to as many cell I want. tq. |
#2
|
|||
|
|||
Put the series in a Custom List (Tools/Options/Custom List). Enter D in
a cell. Drag across or down. In article , "Mohd Rosdi" wrote: Dear Expert, My data patern D, D, N, N, O, O, O, R . If I type D in a1 I want next to follow with the rest of the pattern and repeat the same patern to as many cell I want. tq. |
#3
|
|||
|
|||
"Mohd Rosdi" wrote in :
Dear Expert, My data patern D, D, N, N, O, O, O, R . If I type D in a1 I want next to follow with the rest of the pattern and repeat the same patern to as many cell I want. tq. Maybe I do not understand you correctly, but this is one way I read you: In cell A1 you type D In cell A2 you type D In cell A3 you type N In cell A4 you type N In cell A5 you type O In cell A6 you type O In cell A7 you type O In cell A8 you type R To copy this pattern to other cells, you select cells A1 to A8, put your cursor on the little black square at the bottom right corner of the selection (where it changes to a cross) and drag your cursor down or to the right. The pattern will then be repeated. -- It is I, DeauDeau (Free after monsieur Leclerc in 'Allo, 'allo) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when word is typed in cell, how can the row auto displays data? | Excel Discussion (Misc queries) | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Is there a way to get an auto page break as data changes in Excel. | Excel Discussion (Misc queries) | |||
Repeat Paste of Data | Excel Worksheet Functions |