Please choose the correct ending to complete the given sentence: Computers and Electronics: [header] How to consolidate in excel [title] Verify that data in each worksheet appear in list format. [step] Make sure you have removed any blank columns and rows, and that each column is labeled with similar information. [substeps] Add and layout each column range to a separate worksheet.

Ending1: By highlighting data in your worksheet, you can give it a more complex look. [title] Type data from the worksheet that you need or that is more easily accessible, go to column 2, and click " add. Ending2: [title] Click the " organize " button to separate the column and space it from the rest of the worksheet. [title] Click " data group " to open the " file properties " menu. Ending3: However, do not add the ranges to the master worksheet that you plan to consolidate. Highlight each range, and name them by picking the formulas tab, followed by the arrow located near name a range. Ending4: If you do not want to a columns to have a different preposition, add and layout from various perspectives and perspectives. Do not include the " focus " worksheet.

Answer format: ending1/ending2/ending3/ending4