The CHOOSE function in Microsoft Excel is a Lookup and Reference function, and its purpose is to choose a value from a list of values. The CHOOSE function formula is CHOOSE(index_num, value 1 ...

Click the File tab and choose Options. Choose Advanced in the left pane. In the Editing Options section, make sure the Extend Data Range Formats And Formulas option is checked (Figure L). Click OK.