Merge Printing Part of Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paul bennett - 01 Apr 2004 14:19 GMT

Temporary working on Excel at Work. Need to write to a number of people on
the spreadsheet. So far, I've sorted, then copied data into another
spreadsheet. Then when I've done mail merge, where it says Entire
Worksheet, I click on this. Is there a way of marking the block in the
original worksheet/or stating the cells. If stating the Cells, what do you
put A1 to A10, then rows A1 to A10?

Some assistance would be much appreciated. (or by the way in simple terms,
I'm a bit thick when it comes to Excel)

Reply to this Message

Debra Dalgleish - 01 Apr 2004 23:22 GMT

You could try naming the range of cells. There are instructions here:

http://www.contextures.com/xlNames01.html

> Temporary working on Excel at Work. Need to write to a number of people on
> the spreadsheet. So far, I've sorted, then copied data into another
> spreadsheet. Then when I've done mail merge, where it says Entire
> Worksheet, I click on this. Is there a way of marking the block in the
> original worksheet/or stating the cells. If stating the Cells, what do you
> put A1 to A10, then rows A1 to A10?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message