Right click the tab with the sheet name. Then select Copy and in the
pulldown menu select new workbook.

"Pradhan" wrote:

Is there any way to save a sheet to a different format WITHOUT it changing
the name of the page? Alternatively, in other software, you can usually
export the data leaving the on-screen data intact. Is there any way to do
this? I find the process of saving to a different file format, frankly,
painful. First, you are warned that it is not in excel format, then because
the name changes on the worksheet, you are asked if you want to save the data
in a different format....etc. So, to simply export the page would be helpful.
Any advice?