How do I consolidate rows in excel?
- 1 Answers
- 775 Views
- I also Faced
- E-Mail Answers
Answer / Jyoti Pal
To consolidate rows in Excel, follow these steps:
1. Select the cell where you want to place the result of the consolidation.
2. Go to the Data tab and click on "Consolidate".
3. Choose the function you want to use (like SUM, AVERAGE, etc.).
4. In the Reference box, select the range of cells you want to consolidate.
5. Click OK.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is excel macro?
What is the maximum number of rows and columns in excel 2016?
What is a spreadsheet simple definition?
What are the difference between substitute and replace function in ms-excel?
How do I get my excel spreadsheet back to normal?
How Cell Reference Is Useful In The Calculation?
How do you copy a table from excel to word and make it fit?
How many types of ms excel?
What are basic excel skills?
What type of work in ms excel?
How do I combine data from multiple rows into one in excel?
What is the use of ms excel 2010?
MS Excel Microsoft 
