Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filling cells
When you drag a range of cells, Excel tries to figure out what the interval
is betwen them to add. So if you type Jan, Mar - then drag them, you get all the odd numbered months. if you type 1 and 2, then drag them, it will increase by 1. "art" wrote: I relized that when I write in cell A1 "1", A2 "3", A3 "6". And then I drag down to fill more cells it starts going like, 8.33 10.83, and so on. why does that happen. why can't it understand that I want to increase the numbe by 1? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filling cells with absolute columns but "nth" rows | Excel Worksheet Functions | |||
Filling empty cells with a value | Excel Discussion (Misc queries) | |||
Auto filling cells across mutliple sheets | Excel Discussion (Misc queries) | |||
Filling cells depending on two conditions | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |