Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Formating
How do i formulate the formula in the cell without having doing the pasting
to all the cell wanted and adjusting the formula. Since the formula change when the cell is in the different cell row and column. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Formating
Hi
You need to change some of your cell references to Absolute instead of Relative $A1 locks column letter when copying across the sheet A$1 locks the row number when copying down the sheet $A$1 locks both column and row A1 allows both column and row to adjust as copying takes place. With the cell reference highlighted in the Formula Bar, repeatedly pressing F4 will cycle the reference through the 3 different modes. -- Regards Roger Govier "Ryha" wrote in message ... How do i formulate the formula in the cell without having doing the pasting to all the cell wanted and adjusting the formula. Since the formula change when the cell is in the different cell row and column. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Formula for Conditional Formating - Help! | Excel Worksheet Functions | |||
Conditional formating using array formula?? | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Formula encompassing conditional formating | Excel Worksheet Functions |