Calc only selected cells

[mroseto]

Hello all,

Is there a way to only calc selected cells? This would speed up my spreadsheet.

Thanks

Mike

 

[NBVC]

Go to Tools|Options and Calculation Tab.

Select Manual in the calculation area.

If you are in a cell and hit enter it will calc that cell, if you hit F9, it will re-calc the whole sheet.

 

[Zack Barresse]

Also note that if you change a cell with dependencies outside of your range, those will also be calculated.

 

[mroseto]

Thanks, but I only want to calc certain cells. Is this possible?

Thanks

Mike

 

[Zack Barresse]

Only as described above.