| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Fun With That Wages Book Again
G H
450.00 450.00 (G9) 425.00 875.00 (G10+H9) 430.00 1320.00 (G11+H10) 422.00 1742.00 (G12+H11) 1742.00 1742.00 I have to type in the formula in H each time I make an entry in G in order to get H to complete. If I drag the auto complete down it fills in the last entry all down the column, which I don't want to happen. Why doesn't excel recognise what I'm at and just fill in column H for me? Although the above example only shows four entries, it's the same after seven. The Autocomplete box is ticked. Help anyone? - Gatsby |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A Formula For A Wages Book | Setting up and Configuration of Excel | |||
| linking multiple books (source.xls) to a single book (destination. | Excel Discussion (Misc queries) | |||
| Could you recommend an Excel book? | Excel Discussion (Misc queries) | |||
| book selection when using move or copy tab in excel | Excel Worksheet Functions | |||
| Work book formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
