Please choose the correct ending to complete the given sentence: Computers and Electronics: [header] How to add a filter in excel 2007 [title] Open the spreadsheet in which you want to filter data. [title] Prepare your data for an excel 2007 autofilter. [step] Excel can filter the data in all selected cells within a range, as long as there are no completely blank rows or columns within the selected range.

Ending1: You can rearrange data to make each column appear only in one column. [title] Open excel 2007 from the menu, at the top of the window. Ending2: [substeps] First select a blank cell, and then your column to occupy, then press ctrl + i to select the portion you want to filter data from. Right-click a cell a1, and then select it to filter data. Ending3: Once a blank row or column is encountered, filtering stops. If the data in the range you wish to filter is separated by blank rows or columns, remove them before proceeding with the autofilter. Ending4: [title] Find the column labelled " depend on how many data we have ". [step] This will be the column with all the data in it that is not selected in the results chart.

Answer format: ending1/ending2/ending3/ending4