| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
repeat number multiple times
Excel 2003 SP3
I frequently need to put the week number on a spreadsheet. Example: 1 seven times for week one on rows 1-7 2 seven times for week two on rows 8-14 3 seven times for week three on rows 15-21, etc. Is there a quicker way to do this than just type in the number seven times? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| repeat list 5 times | Excel Discussion (Misc queries) | |||
| Repeat text a number define of times | Excel Worksheet Functions | |||
| Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
| Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
| how do I get a calculation to repeat various number of times? | Excel Worksheet Functions | |||
Threaded Mode
