LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laura
 
Posts: n/a
Default Hiding Rows Leaves Labels Blank

I have an Excel address list of 400 contacts. I'm using mail merge to get
these into Word for label printing. When I edit the Excel chart by hiding
rows 20 to 45, Word will leave those labels blank. In otherwords, I'm seeing
populated labels 1 thru 19....then a bunch of blank labels....then populated
labels 46 to 400.

I made sure the setting "if a blank row exists do not print a blank label"
(or something to that effect) is checkmarked.

Any ideas???? Thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort Macro to Exclude Blank Rows? ScottPcola Excel Worksheet Functions 1 January 5th 06 07:10 PM
Im trying to remove blank rows in an Excel spreadsheet Printout riponalong Excel Worksheet Functions 2 January 5th 06 05:58 AM
macro to hide rows if cell is blank Shooter Excel Worksheet Functions 3 September 28th 05 10:55 PM
Hiding rows based on choice in a listbox robhargreaves Excel Discussion (Misc queries) 1 July 24th 05 12:58 PM
Blank Rows Acesmith Excel Discussion (Misc queries) 1 November 30th 04 09:23 PM


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"