Microsoft Excel allows you to change the order of worksheets within a workbook at any time. There are two ways to do this, the first of which is simply to drag the tabs representing each worksheet to the left or right. Not only can you drag individual tabs, it is also possible to select several tabs and drag them all at the same time.
Not only can we move worksheets around within the same workbook, it is also possible to move worksheets from one workbook to another. For example, suppose you have a workbook containing a worksheet for each month of the year (”Jan”, “Feb”, etc.) and that we now want to split this into four smaller workbooks, one for each quarter: the first containing “Jan”, “Feb” and “Mar”; the second containing “Apr”, “May” and “Jun”; and so forth.
To keep the number of sheets we will end up with in each workbook to a minimum, we could begin by reducing the default number of worksheets Excel will give us in each new workbook. To do this, we click on the Office Button and then choose Excel Options. In the section labelled “When creating new workbooks Include This Many Sheets”, we reduce the number to one. We can now create four sheets by clicking four times on the new sheet icon on the Quick Access Toolbar.
Each of our new workbooks has one sheet, which is the minimum that Excel will allow. We can access these new workbooks by clicking on the View Tab and accessing the Switch Windows drop-down menu. The first method of moving worksheets from one workbook to another is to drag and drop,...Read Full Article From Computer Training
