{{indexmenu_n>2}}
====== Range Set ======

This step is only applicable for target worksheets. The process step **Range Set** (together with **[[..range_cell:cellset|Cell Set]]**) is the Djeeni counterpart of data entry on a worksheet. You can multiply a single value to a range of cells (you do not have to use double quotes to assign text values):

{{ :en:process_steps:range_cell:rangeset1.png?nolink&800 |}}

A value or formula can be set to a range with the following parameters:

  * **Range**: Complete Djeeni range reference with worksheet Djeeni name, column letter and number
  * **Value / formula**: MS Excel value or formula

Just like in Excel you can also assign formulas to cells by starting your value with "=":

{{ :en:process_steps:range_cell:rangeset2.png?nolink&800 |}}

Please note that Djeeni considers the best practice to create your worksheet template first with formulas and then use Djeeni for filling it with data. Setting formulas in a Djeeni process is most of the time unnecessary.