Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
ALL OF A SUDDEN, my copy and paste routines are NOT working...I am copying
down a column a function, if(A3=B3, "WIN", "LOSE"), and copying down. Instead of returning the proper answer, it is returning the value of the cell from which I am copying..i.e. NOT the right answer. I do not understand what I did, but all of a sudden, this spreadsheet is out of whack. Please try to help! Thank you, FLKulchar |
#2
![]() |
|||
|
|||
![]()
Check ToolsOptionsCalculation. Make sure it is set to Automatic.
Hope this helps Rowan FLKULCHAR wrote: ALL OF A SUDDEN, my copy and paste routines are NOT working...I am copying down a column a function, if(A3=B3, "WIN", "LOSE"), and copying down. Instead of returning the proper answer, it is returning the value of the cell from which I am copying..i.e. NOT the right answer. I do not understand what I did, but all of a sudden, this spreadsheet is out of whack. Please try to help! Thank you, FLKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ctrl Page Down/Up | Excel Discussion (Misc queries) | |||
Ctrl C | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |