#1   Report Post  
Michelle
 
Posts: n/a
Default

Thank you - so simple!
--
Michelle


"PC" wrote:

Select the rows from 32 to the end of the worksheet (row 65k) and then
delete them all

Then save, close and re-open the worksheet.

The alternative is to use a dynamic named range for the word merge.

HTH

PC


"Michelle" wrote in message
...
I am using a worksheet that has been used previously and I have deleted
previous data and started anew. My data finishes on row 31, but when I

CTRL
+ END, it goes to row 60 (seems like it is remembering that it had data in
those rows previously). This is causing problems when I merge with Word.
How can I clear these rows? Have tried deleting them, and Edit, Clear

All.

Any help appreciated.
--
Michelle




Reply
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
quattro converter for Excel 2003 cntaylor Excel Discussion (Misc queries) 4 April 30th 07 07:08 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Excel 2003 back to Excel 2002 Pete Carr Excel Discussion (Misc queries) 3 December 27th 04 08:11 AM
Excel 2000 file when opened in Excel 2003 generates errors? Doug Excel Discussion (Misc queries) 13 December 25th 04 10:20 PM


All times are GMT +1. The time now is 04:07 PM.

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"