Compuyer Help with Excel 2007, Please??

Question

I have an Excel Workbook with several tabs. How can I save just one tab from that Workbook to another Workbook?>

For example: How can I save Tab A to a separate Workbook??

Answer 1

Right click on the tab and select 'move or copy', then the drop down windows give you selections to other files that you already have open. Be sure to check the box the says 'create a copy' otherwise it will move the page from one file to another instead of making a copy in the other file.