Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Spreadsheet
How can I lock the rows and columns in a spreadsheet but allow the user
to change the data in the cells. Also, in this same spreadsheet I have multiple formulas on multiple rows, I have found if I add a row the row number is changed and therefore changes the outcome of the formula. If I add a row how can I prevent it from effecting the formulas already in place. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Spreadsheet
Formulas entered in cells on the spreadsheet are either relative references
or absolute references to other cells. The relative references automatically change when the configuration of the sheet changes, plus or minus rows or cut and paste cells and ranges. Absolute references will maintain their reference to the specific cells regardless of configuration changes. In either case, adding or deleting rows and columns, or cutting and pasting cells and ranges could change the results of your formulas. You need to be aware of where your formulas and their linked cells reside when you make changes to you sheet. "DBM" wrote: How can I lock the rows and columns in a spreadsheet but allow the user to change the data in the cells. Also, in this same spreadsheet I have multiple formulas on multiple rows, I have found if I add a row the row number is changed and therefore changes the outcome of the formula. If I add a row how can I prevent it from effecting the formulas already in place. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Spreadsheet
If you don't want the formula to change when you insert or delete rows or
columns, try the INDIRECT() function. -- David Biddulph "JLGWhiz" wrote in message ... Formulas entered in cells on the spreadsheet are either relative references or absolute references to other cells. The relative references automatically change when the configuration of the sheet changes, plus or minus rows or cut and paste cells and ranges. Absolute references will maintain their reference to the specific cells regardless of configuration changes. In either case, adding or deleting rows and columns, or cutting and pasting cells and ranges could change the results of your formulas. You need to be aware of where your formulas and their linked cells reside when you make changes to you sheet. "DBM" wrote: How can I lock the rows and columns in a spreadsheet but allow the user to change the data in the cells. Also, in this same spreadsheet I have multiple formulas on multiple rows, I have found if I add a row the row number is changed and therefore changes the outcome of the formula. If I add a row how can I prevent it from effecting the formulas already in place. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Extract Data from Spreadsheet | Excel Worksheet Functions | |||
Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
Can I format columns to move across a spreadsheet? | Excel Discussion (Misc queries) | |||
Save a spreadsheet in.csv format ? | Excel Discussion (Misc queries) | |||
Can I insert excel spreadsheet in word and keep currency format? | Excel Discussion (Misc queries) |