| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repetitive Data in Excel
Is there a formula so that I can have excel enter the same number every 10th
cell in a row? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repetitive Data in Excel
Enter say 25 in A1 and K1.
Select A1 to T1. Click on the fill handle of the selection, and drag along Row1 as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Exceldummy" wrote in message ... Is there a formula so that I can have excel enter the same number every 10th cell in a row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get data from a web page to chart in excel. Any solutions? | Excel Discussion (Misc queries) | |||
| Excel: How to choose data on two separate rows in the same column | Excel Worksheet Functions | |||
| Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
