Changes

===== Adjusting the Calculated Columns Excel User Setting =====

===== Adjusting the Calculated Columns Excel User Setting =====

The new RCC uses tables (learn about them here). Sometimes it is helpful to enter an input value by using a formula directly in a cell in a table, but if a column is entirely blank, then Excel will apply a formula entered in row 1 to all other rows in that column by default. This can be annoying if you only want the formula to apply to a single row, since you will have to delete the formula in subsequent rows. This auto-filling behaviour is called "calculated columns" and the setting can be turned off in Options > Proofing > Autocorrect Options > AutoFormat as you type:

The new RCC uses tables. Sometimes it is helpful to enter an input value by using a formula directly in a cell in a table, but if a column is entirely blank, then Excel will apply a formula entered in row 1 to all other rows in that column by default. This can be annoying if you only want the formula to apply to a single row, since you will have to delete the formula in subsequent rows. This auto-filling behaviour is called "calculated columns" and the setting can be turned off in Options > Proofing > Autocorrect Options > AutoFormat as you type:

[[File:Excel User Setting.png|center|alt=|thumb|600x600px]]

[[File:Excel User Setting.png|center|alt=|thumb|600x600px]]

The last box should be unchecked ("Fill formulas in tables to create calculated columns).  

The last box should be unchecked ("Fill formulas in tables to create calculated columns).