what do you mean by data …
CBSE, JEE, NEET, CUET
Question Bank, Mock Tests, Exam Papers
NCERT Solutions, Sample Papers, Notes, Videos
Posted by Bobby Dubey 4 years, 9 months ago
- 1 answers
Related Questions
Posted by Jatin Jaat 1 year, 1 month ago
- 0 answers
Posted by Chandan Kedia 1 year, 1 month ago
- 0 answers
Posted by Sakshi Pradhan 1 year, 2 months ago
- 0 answers
Posted by Account Deleted 1 year, 1 month ago
- 0 answers
Posted by Manyata Mishra 1 year, 1 month ago
- 0 answers
Posted by Swastik Mishra 1 year, 2 months ago
- 0 answers
Posted by Sudharshini Kanthasamy 2 weeks, 5 days ago
- 1 answers
Posted by Ayushi Singh 1 year, 1 month ago
- 0 answers
Posted by Pavi S 1 year, 1 month ago
- 0 answers
myCBSEguide
Trusted by 1 Crore+ Students
Test Generator
Create papers online. It's FREE.
CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
Gaurav Seth 4 years, 9 months ago
Step 1: Open all files (workbooks) that contain the data you want to consolidate.
Step 2: Ensure the data is organized in the same way (see example below).
Step 3: On the Data ribbons, select Data Tools and then Consolidate.
Step 4: Select the method of consolidation (in our example, it’s Sum).
Step 5: Select the data, including the labels, and click Add
Step 6: Repeat step 5 for each worksheet or workbook that contains the data you need included
Step 7: Check boxes “top row”, “left column”, and “create links to data source” (note you don’t have to tick these boxes if you don’t want labels or don’t want live links) and click the OK button.
1Thank You