Worksheet to new file

G

Guest

I have more than 100 worksheet in a sheet and i want to save this worksheet
as workbook at once. I can do I one by one. Please help me on this.

Jai
 
G

Guest

Hi,

Could you elaborate a bit.

I assume 100 worksheet in a Workbook and not 100 worksheet in a sheet.

Caution:
There is no command as Save ALL. You can close all the Workbook you have
opened, by pressing the Shift Key and then selecting the Close All command
from the File menu.

Challa Prabhu
 

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

Control Button 2
Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Cannot copy worksheet to another file 2
New Workbook from all sheet of a workbook 2
extract data from multple worksheets to a summary worksheet 2
Saving only current worksheet into new file 3
Summary worksheet referencing 100 worksheets 2

Top