answersLogoWhite

0


Best Answer

All the data should be put in a single worksheet and that worksheet can be specified when the mail merge is being made, so it doesn't matter if there are more worksheets.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: When the data source you select for a mail merge is an Excel workbook that has more than one worksheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is a spreadsheet referred to in Excel?

An Excel spreadsheet is referred to as a worksheet. A collection of worksheets is called a workbook.


When the data source you select for a mail merge is an Excel workbook that has more than one worksheet what does Word do?

It gives you a choice of where to choose the data from. It is important to set up your data in the Excel document in a structured manner with clear headings so that you can find it, whichever worksheet it is on.


Is it TRUE that Excel opens with a new blank workbook displayed?

Yes, when you start Excel in the normal way, you will be presented with a blank workbook. However, you can choose an Excel file from your folders before opening Excel, and if you double click on it, it will start Excel and have that file open when it starts, instead of a blank workbook.


Is a worksheet always stored in a workbook in Microsoft Excel?

Yes, an MS Excel worksheet is always stored in a 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 pages in spreadsheets?

If you mean what is the name of the worksheet in an Excel workbook, it is the name on the tab at the bottom of the screen. To change the name, right-click on the tab and select rename.


What sequences would delete a single worksheet from an Excel workbook?

Right click on the worksheet name (usually Sheet1, Sheet2 unless you have renamed it), Select Delete, and confirm delete.


What is one page of data in an excel workbook called?

worksheet


What is the worksheet that appears in the workbook window in excel?

Active Sheet.


Can additional worksheets be created from a workbook in Excel that defaults three worksheets?

yes. If you right click on the bottom left cormer of excel where the tabs are, click new and select worksheet. you can do this from here.


What does a new worksheet icon looks like in Excel?

There is a specific icon for a new workbook, which is a whole new file, but not a worksheet. To add a worksheet to the existing workbook, go to the Insert menu and choose Worksheet.


What is a collection of cells in an Excel worksheet called?

A workbook in Excel is a collection of worksheets, which may be what you mean. There is no particular name for a collection of workbooks. They are just workbooks or spreadsheet files.