Calc only selected cells

mroseto

Board Regular
Joined
Jul 18, 2002
Messages
203
Hello all,

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

Thanks

Mike
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Also note that if you change a cell with dependencies outside of your range, those will also be calculated.
 

mroseto

Board Regular
Joined
Jul 18, 2002
Messages
203
Thanks, but I only want to calc certain cells. Is this possible?

Thanks

Mike
 

Watch MrExcel Video

Forum statistics

Threads
1,118,088
Messages
5,570,147
Members
412,306
Latest member
fabio6
Top