0
Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another in the workbook?
Wiki User
∙ 14y ago
Worksheet
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Most excel specialists who build web queries use the worksheet returned from the web query as an engine to supply to another?
range
What will happen when you drag and drop a worksheet tab into another workbook without holding the Ctrl key down?
It will move the worksheet to the other workbook.
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.
Why won't excel copy a worksheet?
You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.
Can you email just one worksheet in a work book?
The best thing is to copy it to another workbook and e-mail that one. You can either copy the data to a new sheet, or copy the entire sheet to another workbook. Then you could delete the other worksheets in the new workbook and save and e-mail the workbook.
Where can I find this worksheet online?
Unless there is a URL at the bottom of the page it might be hard to find the worksheet again. If it is from a specific workbook you might need to order another or see if the school has one on file.
What is a link in Excel?
A link in Excel can be like a link on a webpage. By clicking on it, it can enable you to jump to different parts of the worksheet, different parts of the workbook, to a different workbook, to another kind of file and to a webpage. Another type of link is where data in one workbook is linked to data in another workbook or other kind of document. When data is updated in one, it will also change in the other document, as it is looking at data it is linked to.
What is the difference of a workbook and a spreadsheet?
A workbook contains worksheets, in the same way that a book contains pages. A workbook file consists of one or more worksheets.
What is source workbook in MS-Excel?
If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.If you have data in one workbook that is coming from another workbook then the second workbook is the source workbook, as it is the source of the data in the first workbook.
How do you link to another excel file in a formula?
Include the external workbook (surrounded by []) and worksheet names (followed by !) in the formula:=SUM([workbook.xls]worsheet!A1:A23)
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.
In Excel how do you copy an entire worksheet and all its data?
To copy it to another workbook, you can right click on the Sheet Tab and pick the Move or Copy option. To copy it into the same workbook. Click on the sheet tab and then press Ctrl and drag the sheet tab to copy it.
