Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 auto fill help
I used to use this method to fill in Excel 2003; however, it is no longer
working for me in Excel 2007. I wanted to auto-fill from 181A to 189A and entered the first 4 cells. After highlighting cells 181A to 183A and dragging the little square down, all I received was 181A to 183A in repeats. Can you help please? p.s. I cannot customize the list because every time the senario is different |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 auto fill help
?B?andvbmc=?= wrote in
: I used to use this method to fill in Excel 2003; however, it is no longer working for me in Excel 2007. I wanted to auto-fill from 181A to 189A and entered the first 4 cells. After highlighting cells 181A to 183A and dragging the little square down, all I received was 181A to 183A in repeats. Can you help please? p.s. I cannot customize the list because every time the senario is different Excel needs to be able to understand the sequence order to autofill. Excel does understand simple mathematics: Excel understands 2,4,6,8 (increase by two) Excel understands 9.6.3 (decrease by three) Excel does not understand 1,2,3,5 (Fibonacci sequence) Excel does not understand 2,4,8,16 Provided there is a mathematical relationship between numbers, you can work around the sequences Excel does not understand using formulae.For example: Fibonacci sequence A1 - 1 A2 - 2 A3 - =A1+B1 Drag down the A3 formula Multiplication A1 - 2 A2 = =A1*2 Drag down the A2 formula -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Excel Auto Fill - Lower right corner | Excel Discussion (Misc queries) | |||
Excel 2007 auto-recovery / auto-save? | Setting up and Configuration of Excel | |||
auto fill rows in Excel 2007 | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Using Excel Auto Fill | Excel Discussion (Misc queries) |