Complete the following steps to fill a column with a pattern of equally-spaced numbers, such as the numbers 1 through 100, or five sets of 1, 2, and 3.

- In Store patterned data
in, enter a column number (for example,
`C1`) or column name. If the name contains spaces, enclose the name in single quotation marks. - Enter the sequence of numbers in the pattern.
- In From first value, enter the first value of the sequence. You can enter stored constants (K) instead of numbers.
- In To last value, enter the last possible value of the sequence.
- In In steps of, enter the increment for the sequence.

- Enter the repeat information for the pattern.
- In Number of times to list each value, enter the number of consecutive times to list each value in the sequence.
- In Number of times to list the sequence, enter the number of times to repeat the entire sequence.

For example, these settings create the following column of data.

- From first
value:
`10` - To last
value:
`14` - In steps
of:
`2` - Number of times to
list each value:
`2` - Number of times to
list the sequence:
`3`

C1 |
---|

Numbers |

10 |

10 |

12 |

12 |

14 |

14 |

10 |

10 |

12 |

12 |

14 |

14 |

10 |

10 |

12 |

12 |

14 |

14 |