Automatic detection of the sort and filter range

MyOffice Spreadsheet can automatically detect the sort and filter range if the cells adjacent to the selected one contain data. Data in adjacent cells can be of any format.

To automatically detect the range, follow these steps:

1.Select the empty cell that is adjacent to the range.

2.Enable sorting and filtering in one of the following ways:

•On the Home tab, in the Data, click  Filter.

•On the Data tab, click  Filter.

•Right-click the selected range and select Filter from the context menu.

•Press Ctrl+Shift+L (Windows, Linux) or ⌘Cmd+⇧Shift+L (macOS).