0
How can you show only specific data on a worksheet in a workbook?
Wiki User
∙ 14y ago
It depends on what you are trying to do. Here are some ways you can show specific data:
- Delete the data you do not want to show.
- Hide the row or column of data you do not want to show.
- Change the font color to the same color of the cell background (usually white).
- Put your calculations and data on one worksheet and display the results on another worksheet. You then can hide the worksheet you do not want anyone to see.
Wiki User
∙ 14y 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.
What is the differense between workbook and worksheet?
A worksheet is only one sheet; whereas a workbook contains several sheets. These terms are often used in Microsoft Excel.
Can part of data in excel be saved as a file?
If you only want part of a worksheet to be saved, then copy the section you would like to save, open a new workbook, paste the section into a worksheet, and save the new file.
Is the only way to copy a worksheet in a workbook it to use the copy command on the shortcut menu true or false?
false
What is a saved worksheet called?
You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.You may mean a Workbook, as a workbook consists of several worksheets, even if you only use one.
When you open an Excel workbook how many sheets by default does a workbook have?
It depends what version you are using. Excel 2013 only has one worksheet by default, but earlier versions had three. Note that you can change the number of sheets when creating a new workbook via Excel options.
Wheres a worksheet file that is active?
It is the worksheet that you are looking at and working on at any given time. You may have many worksheets in a workbook and even many workbooks open, each with many worksheets, but you can only have one active worksheet, which is the one you are currently working in.
Which of the following formats means that users can view but not change data in a workbook?
read only
When a workbook is made available to users will they be able to enter data in only the unprotected cells?
yes
What is unique for each cell in an Excel worksheet?
Its address.For example, there is only one cell in a worksheet called A3. If you have multiple worksheets, you would have the same number of cells called A3 within that worksheet, but within the entire workbook, you still would have only one cell called Sheet1!A3.
What is a chart sheet in chart in excel?
A chart sheet just shows a chart by itself, so you don't see the data and there are no rows and columns visible.
Can Worksheet cells only contain numbers?
No. A worksheet can hold all sorts of data, like text, dates, number, logical values and formulas.
