0
Often the main data needs supporting data, which doesn't necessarily need to be seen. Data may be sourced from lookups for example. Instead of having them on the same worksheet as the main data, you can put them onto a separate sheet and reference them and hide that sheet. If all of the supporting data is on a separate worksheet, it can help tidy up the main sheet, making it easier to follow. It also gives you more flexibility to design it better. You may also want to keep some data private, so it can be hidden on other worksheets. Sometimes, you want to have different versions of the same worksheet for different users, so you could have similar worksheets hidden in one version that is not hidden in another. So there are lots of reasons for hiding worksheets.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
When would you use a worksheet and when would you use a workbook?
You use a worksheet when you want to have only a single spreadsheet. You will use a workbook when you have multiple worksheets.
How many worksheets does Excel have when it opens a new workbook?
In Microsoft Excel, a new workbook will normally have three worksheets.
How can you separate the worksheets within a workbook into their own files in excel?
There is no automatic method to save each worsheet as a separate file, you need to do that manually. If you have three worksheets, then save the file two more times, so you have three worksheets instead of only one. Open each workbook and delete the worsheets you do not want in that file. Repeat the process until you have only one worksheet in each workbook.
How do you move a worksheet in Excel 2007?
The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.
What is the difference between a workbook and template?
A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.A workbook contains worksheets in Excel. A template is a predefined layout of a workbook that can be used over and over, saving you having to re-do standard parts every time you want to use it. So it can have things like headings put in already, and you just have to enter the data.
Can the number of worksheets in a workbook be changed?
This question is not clear. 1) If the worksheet is not locked (protected with a password), you can change numbers to anything you want them to be. However, you should be careful about trying to change formulas unless you understand the consequences. 2) If you want to add more worksheets to the workbook, just click on the tab at the bottom of the page to add another worksheet.
How many worksheets does the default setting for a new Excel workbook contain?
By default there are 3 sheets in a new Excel workbook.
Explode Excel worksheets into separate Excel workbooks?
If your Excel workbook has several worksheets and you want to save them into separate Excel workbooks, try the following: Position your mouse on the worksheet tab (bottom left of the screen). Right mouse click on the worksheet tab and select "Move or copy" from the shortcut menu. This opens the Move or Copy dialog box. In the "To book:" field, choose "(new book)"Click the check box for Create a copy if you want to keep the worksheet in the original workbook, or leave it unchecked if you want to move the worksheet from the original workbook. Click OK to finish the steps.
To from one worksheet to another you click the sheet tab of the desire worksheet?
This question is not clear. If you have multiple worksheets in a workbook, you can click on the tab of the worksheet you want to display. To go to another worksheet, just click on its tab.
What is renaming worksheet tab in MS Excel?
When you start an Excel workbook, there are three worksheets in it called Sheet1, Sheet2 and Sheet3. If you are doing something you might want to use more meaningful names for them. So the worksheets can be renamed. If you right click on a sheet tab, you can pick the Rename option and put in a new name for the sheet.
Why excel uses 3 sheets at same time?
When you create a new workbook the default number of worksheets is 3. It is just the automatic number created. If you don't want it to do this you can change the default number created in future. Click on the help icon and type in "change default number of worksheets" and read the article for more information.
Where can I find math practice worksheets for high school students?
If you want practice worksheets for high school students , just go to http://havefunteaching.com/worksheets/english-worksheets/alphabetical-order-worksheets/. Once there just select the worksheets wanted.
