When you sort a range that contains Snips in Excel, DataSnipper lets you choose whether the Snip references move with the sorted data or stay in place. This article explains the options and how to set a default.

1. Select the range you want to sort in Excel.

2. Start your sort, for example the Data tab, then Sort.

3. If the range contains Snips and the sort would move them, a dialog appears.

4. Choose one of the following. Update Snip references moves Snips to follow the sorted data. Sort values only sorts the cells but leaves Snips where they are.

5. Tick "Apply this choice for this workbook session" if you want the same option used automatically for the rest of the session.

6. Click the relevant button in the pop-up to proceed.

If you apply the choice for the session, it is used automatically for future sorts in this workbook until you close Excel, with no further pop-up.

To avoid pop-ups entirely, open DataSnipper, then Workbook Settings, find Snip sorting, and choose one. Always ask me (the default) shows the pop-up when a sort would move Snips. Always sort with references moves Snips with the sort. Always sort values only sorts cells and leaves Snips in place.

To change or clear your choice during the session, go to Workbook Settings, then Snip sorting, and select a different option or Always ask me. After you reopen Excel, the workbook returns to Always ask me.

Sorting that moves Snips clears the undo stack. If you are co-authoring and want everyone's Snips to stay aligned with the data, choose Update Snip references.