Tabs, or worksheets, in an Excel workbook can easily be rearranged, copied or moved.  You can change the order of tabs in a worksheet simply by dragging them and dropping them wherever you want.  If you arrange two workbooks so you can see them both, you can move a tab from one workbook to the other by dragging it from one window and dropping in the other.  If you hold down the control key on your keyboard while dragging a tab , Excel will copy the tab instead of moving it. If moving or copying a tab results in two tabs with the same name, a number will be added to the end of the tab name. Copying a tab has an advantage over copying cells in that all formatting, including columns widths is preserved.

If you have a large number of tabs in a workbook or if you have several windows open, there is another method that can be easier than drag and drop.  Right click on the tab you want to move or copy and choose Move or Copy.  At the bottom of the window, check the Create a copy box if you want to copy instead of move.  If you want to copy/move to a different workbook, select it in the To Book drop down list (the workbook has to be open already) or choose New Workbook. In the Before Sheet section select a location within workbook and click OK.

With either method you can copy/move multiple worksheets at once. Simply click on the first tab you want to select, then hold down the Shift key and click on the last tab you want to select it and all the tabs in between. Or you can hold down the Ctrl key while clicking to add (or remove) individual tabs to your selection. Then continue with either method to copy/move all of the selected worksheets at once.


[Facebook] [LinkedIn] [StumbleUpon] [Twitter]