Changes

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

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

There is a default user setting in Excel that makes using the RCC worse, if people ever want to put formulas into table inputs. If you put a formula in the first row and the subsequent rows are blank, it auto-fills the formula all the way down. It's called "calculated columns" and the setting is in Options > Proofing > Autocorrect Options > AutoFormat as you type

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 by default Excel will apply a formula entered in row 1 to all other rows in that column. 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. But when that undesirable behaviour happens, a little box also pops up, and the setting can be changed there:

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

 

 

Alternatively, whenever a calculated column is creates a little box will pop up in the table, and the setting can be changed there by clicking "Stop Automatically Creating Calculated Columns":

[[File:Alternate Method.png|center|frame]]

[[File:Alternate Method.png|center|frame]]