Excel

  • Thread starter Thread starter Patty
  • Start date Start date
P

Patty

Is there a way to make separate Excel files for each
worksheet short of using copy or save as?
 
Patty,

If you right click the sheet tab of the worksheet, you can click "mov
or copy". Select that and then under the "to book" drop down list
select new book. This will create a new workbook for you with onl
that sheet inside.


Hope this helps,



Jerr
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
make copies of worksheet for each day of month 1
Cannot copy worksheet to another file 2
Can I quickly split up worksheets into different files? 4
export sheets to multiple new files 3
Linking multiple ranges and worksheets to MS Word 1
Counting multiple memberships 1
excel 2010 + copy array 3

Back
Top