A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM function which ... Jun 17, 2019 · In Excel 2013, these are labeled Sort Smallest to Largest and vice versa. For a more complex sort, go to the Home ribbon, click the arrow below the Sort & Filter icon in the Editing group and choose Custom Sort. This takes you to the same Sort dialog box you get with the Sort icon in the Sort & Filter group of the Data ribbon. 1. This is useful if you need to sort multiple levels that share some criteria, such as the same Column, Sort On, or Order. To change the sorting priority: From the Data tab, click the Sort command to open the Custom Sort dialog box. Select the level you want to reorder. Use the Move Up or Move Down arrows. The higher the level is on the list, the higher its priority. Re: Preserve Formula References After Sort. Just found this in Walkenback's "Excel 2003, Power Programming with VBA" page 49. "Start by selecting the range you want to modify. Then choose the Insert > Name > Apply command. In the Apply Names dialog box, select the names that you want to apply then click OK." Feb 25, 2016 · In some cases though, the results become incorrect, after you sort the main items. NOTE: This can affect other Excel formulas too, such as an INDEX/MATCH lookup formula.