| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I add a row to excel how can I stop formulae changing
I've done this before, but can't remember how.
I want to add a row at the top of a sheet, but without formulae with a range eg =sum(a1:a5) changing to =sum(a2:a6). $ isn't the answer |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I add a row to excel how can I stop formulae changing
=SUM(INDIRECT("A1:A5"))
HTH Kostis Vezerides |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I add a row to excel how can I stop formulae changing
"vezerid" wrote: =SUM(INDIRECT("A1:A5")) HTH Kostis Vezerides Thanks for that. How about if I after inserting a row A1:A5 changes to A1:A6 TIA Dave |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i stop excel from changing a dash to a zero in a cell? | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) | |||
| Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) | |||
| how do i get excel to stop changing my input 5-9 to 9-May???? | Excel Discussion (Misc queries) | |||
Linear Mode
