answersLogoWhite

0


Best Answer

One method is to copy a worksheet as many times as you would like to split data. If you have a worksheet that contains three sets of data you would like to display on separate sheets, then copy the sheet two more times, so you have three total copies. On each sheet, delete the data you do not want to display on that sheet. Repeat the process for all sheets, until each sheet contains only the data you want to display on that worksheet.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you split excel sheets to many worksheets?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How many worksheets does the default setting for a new Excel workbook contain?

By default there are 3 sheets in a new Excel workbook.


How many number of sheets can you create in Microsoft Excel?

You can have over 200 worksheets in a workbook. For Excel 2007 and higher, the actual number of sheets is limited only by the amount of memory available to Excel.


How many worksheets are present is Microsoft Excel?

Quote from the web: "According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it.) In my experience, even if you could generate a well-formed workbook with 650 sheets, it is unlikely that any Excel user would be able to open it without running into Excel's memory limit. I'm impressed that you could even get to 200 sheets without a problem, honestly. "


What the maximum number of worksheets you can include in a workbook in Excel?

In Microsoft Excel, a new workbook will normally have three worksheets.


How many worksheets are in excel?

three


No of sheets in a excel book?

There are four worksheets to each book, but you can add more, insert/worksheet not sure how many you can have in total but I know that version 2007 inserts many more rows and sheets than previous versions.


How many worksheets does Excel have when it opens a new workbook?

In Microsoft Excel, a new workbook will normally have three worksheets.


What do you call the sheets in excel?

Normally when you open Excel there are 3 sheets open. They are Sheet1, Sheet2 and Sheet3. Sometimes you will want to give more meaningful names to those sheets. By right clicking on the sheet tab and clicking the Rename option or by double clicking, you can rename a sheet. So you could have many sheets with names on them that are meaningful to what you are doing, which is what we mean by naming sheets.


How many worksheets are present when you open Excel?

3


How many worksheets can you hide in Excel?

You can hide all the worksheets in the workbook. A workbook can have as many worksheets as your computer's memory will allow, so there is no set maximum.


How many worksheets are there in Microsoft Excel?

Excel 2003 and earlier are limited to 255 worksheets per workbook. There are usually 3 by default when you start Excel, but you can add more or change the default.


How many worksheets can you have in any one excel document I understand a spreadsheet can have 1048576 rows and 16384 columns does this mean total rows for all worksheets in the one document?

Those numbers are for each worksheet. You can have as many worksheets in an Excel 2007 workbook as the memory in your computer will allow. Excel 2003 and earlier are limited to 255 worksheets per workbook.