Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, use a different row for headings (not row 1)
Hi! I'm trying to do a mail merge from an Excel sheet. Unfortunately, it was
set up with some other information in the first few rows. Can I mark a different row as the header row for my data? They are in row 5. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, use a different row for headings (not row 1)
Patti
Give your range a name using InsertNameDefine i.e. Select the range A6:H123 and name it Mailname When in Word, refer to that name as the source. Alternate..............Cut the few rows and paste to another sheet. You can always bring them back later. Alternate...............Copy the mail merge data to a new sheet. Move that sheet to first in the workbook. Word will use that first sheet by default. Gord Dibben MS Excel MVP On Fri, 22 Sep 2006 07:25:01 -0700, Patti wrote: Hi! I'm trying to do a mail merge from an Excel sheet. Unfortunately, it was set up with some other information in the first few rows. Can I mark a different row as the header row for my data? They are in row 5. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |