Join Dennis Taylor for an in-depth discussion in this video Splitting and consolidating workbooks, part of Excel Tips Weekly.
- View Offline
- At times you may want to split worksheets…of a given workbook, say this one here,…into different files.…We might want to have a file…for California, Texas, Florida, and New York.…And at other times, the reverse might be true.…You might have different workbooks,…you might want to consolidate them into a single workbook.…Let's show both approaches.…First of all, if we do want to split…this particular workbook into different workbooks,…we could save this four times,…each time under a different name.…Using the command sequence: File, Save As.…
So we could save this as California,…save it again as Texas,…and as Florida, and as New York.…And then open each file and get rid of the worksheets…that are not really relevant to that particular state.…So that's certainly one way of splitting this…into four separate files.…Another way, slightly more visual,…and one that we can show you…a little bit better on the screen,…is simply to create, three new workbooks,…and then drag the relevant sheets into each workbook.…So we got a workbook open already,…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.