Loans that are not eligible for consolidation include state or private loans that are not federally guaranteed.Although all of these different loans may be consolidated, you must have at least one outstanding FFEL or Direct Loan to obtain a Direct Consolidation Loan.If all of the spreadsheets use the same category headings, you can merge data by category name regardless of where the categories and data are located on the spreadsheets.You can also drag to select the desired cells to merge in the wizard to reference the cells by position only, regardless of category name or data type. Open Excel, and then open the first of the spreadsheets to be merged.
With just a few exceptions, you get only one chance to consolidate with the government loan programs.
As you can see in the screenshots below that we have included three worksheets containing students records in each exam.
Exam 1: Repeat the same procedure in other sheets to assign them name range exam2 and exam3 respectively.
Launch Excel 2010, and open a spreadsheet on which you want to apply data Consolidation.
For instance, we have included worksheet, carrying student records, containing marks obtained by student in different exams.