Hi!
I have recently switched to a new computer using windows 7
In the past, in order to auto format a large amount of cells with a formula and values, all I would have to do was enter the formula in a couple of cells and then click on them and drag.
Now, clicking and dragging put the formulas into the new cells, but the value does not show until I click on each individual cells formula bar and press enter.
Could someone please tell me how to set the auto format so that the value is copied and shown automatically (and not just the formula)
Thanks
I have recently switched to a new computer using windows 7
In the past, in order to auto format a large amount of cells with a formula and values, all I would have to do was enter the formula in a couple of cells and then click on them and drag.
Now, clicking and dragging put the formulas into the new cells, but the value does not show until I click on each individual cells formula bar and press enter.
Could someone please tell me how to set the auto format so that the value is copied and shown automatically (and not just the formula)
Thanks