in which menu consolidate is available in spreadsheet
Answers
Answered by
2
Explanation:
Select the upper-left cell of the area where you want the consolidated data to appear. On the Ribbon, Choose Data > Consolidate to view the Consolidate dialog: In the Function box, click the summary function that you want Excel to use to consolidate the data.
Similar questions