ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   save a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/59870-save-worksheet.html)

Caveman

save a worksheet
 

Can i save just a single worksheet from a workbook, instead of the whole
workbookas this happens when you clik save


--
Caveman
------------------------------------------------------------------------
Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=492572


Norman Jones

save a worksheet
 
Hi Caveman,

Right-click the sheet tab
Move or Copy
Select (new book) in the first dropdown
Check the 'Create a Copy' option box
OK

---
Regards,
Norman



"Caveman" wrote in
message ...

Can i save just a single worksheet from a workbook, instead of the whole
workbookas this happens when you clik save


--
Caveman
------------------------------------------------------------------------
Caveman's Profile:
http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=492572




Norman Jones

save a worksheet
 
Hi Caveman,

And, the final step...

Save the new single sheet workbook


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Caveman,

Right-click the sheet tab
Move or Copy
Select (new book) in the first dropdown
Check the 'Create a Copy' option box
OK

---
Regards,
Norman



"Caveman" wrote in
message ...

Can i save just a single worksheet from a workbook, instead of the whole
workbookas this happens when you clik save


--
Caveman
------------------------------------------------------------------------
Caveman's Profile:
http://www.excelforum.com/member.php...o&userid=27546
View this thread:
http://www.excelforum.com/showthread...hreadid=492572







All times are GMT +1. The time now is 09:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com